Hello Koders,
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.?
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.
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