Work in Progress: How to Bring Data from Google Sheet
Last updated
Last updated
Make the first row of your spreadsheet the header: The first row of your sheet will be used as the header. This is the most important part of preparing your sheet, as the names you use here will be used as the property names in the returned objects. Each column in your sheet represents that property’s value.
Go to
Click on "Connect Google Sheet"
Sign in with your Google Account
Create a New Project "From Google Sheet"
Paste the URL of your Google Sheet
Click on "Create Project"
Copy the example code, it should look something like this:
Go to the "All" Tab of the Left Sidebar
Scroll down to the Computed Fields section and create a new one
Give it a cool, original name. Something like "google_sheet"
Scroll to the bottom of the Options Tab on the Right Sidebar
Click on "Generate Sample Code", it will generate an empty function:
Paste the code from Sheety inside the function