in my previous project i was retrieving data from each column from an airtable spread sheet
i was trying this morning without success trying to do the same method but using google sheet hosted in drive any help please.?
the screenshoot show airtable version
Why you guys don’t give a direct help in this forum and transfer us to another forum community !?
Simple. Why the answer already exists, so we research and post.
i saw all the tutorials there i didnt found the one i need actually ? can you answer my question in blocks ?
you might want to try this solution
App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps together with a query, for example
to get all rows of column D
Am here to introduce Cloudsheets - A dedicated service to link your google spreadsheet with app.
The extension is free to use but need an API that can be generated from our website :
A special mention to @help_cttricks for being by my side in the whole development process and helping me with solutions
Advantages of using google spreadsheet as your app’s database over Airtable :
1 - Its completely free to use where Airtable on the other han…
Have a look at this post.
This extension can fulfil your requirement precisely and you can perform a lot more actions to google sheets from your app with this extension.
Using this guide I could learn how to get information from Google Sheets.
I believe these could help …
How to write:
How to read:
i have data from google sheet, and i am using list from csv table but i wanna take only data in column that i wanna.
I have column ; No, Username, Password
I just wanna get data in Username column
annyone can help me how to solve that?
I wonder if that’s what you need.
Am easier way is to use this extension
Hope it helps
You can do it easily just need to export the Google sheet as csv and use select item list block
Hello, thanks but can you please clear more about this ?
If you just want to read column from one sheet of your Google spreadsheet then just copy the link of your spreadsheet and change the ‘edit?usp=sharing’ to ‘export?format=csv’ this should be the web components URL
This way you will egt the data in csv format
Then you just need to select the coloum using this method
You have to use the select list item block as shown in the image above. In this example it’s getting data from line 3 column 2.