How to Bring Data from Google Sheet

The best way for us to make use of big chunks of information on the flow is in the form of a JSON Object. Google Sheet doesn't do that on its own, so we recommend going through an API called "Sheety".
Step 1: Prepare your Google Sheet 
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.
For more info on how it works click here​
Step 2: Get your Sheety Code
Go to sheety.co 
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:
Make sure to return your fetch. Even though the code that Sheety gives you looks like the above, it should actually say "return fetch(url)" and it should look like the last image on this page.
Step 3: Create a Computed Field
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
Remember to change the code so it returns the JSON, or the part of the JSON that you need. 

How to Store a Password

How to Fetch Safely from Savvy

Last modified 1mo ago

Copy link

Contents

Step 1: Prepare your Google Sheet

Step 2: Get your Sheety Code

Step 3: Create a Computed Field