Google Sheets API External Collection

Get Help
1

Hi all

Very new to Adalo and i’m wondering how i can link my Google sheets to my Adalo as an external collection. The process appears to be very simple however i’m not sure what I need to enter for the following;

  • API Base URL
  • Auth Setup

Any help very much appreciated!
Thanks

2 Likes
2

Try through sheetdb

3 Likes
4

Hi all,

I was searching for a solution that excludes external providers and it’s free. I found this article:

I managed to set up and connect Google Sheets.

It supports:

Delete
Insert
Update
Select functions

Once you set up Autocode (free account) you will be able to find your endpoints here:

https://autocode.com/lib/YOURDOMAINNAME/gsheets-database-example/

2 Likes
5

Question: we shouldn’t need Autocode/Zapier/Integromat to export our data to Google Sheets, right?

As long as we can figure out the proper api base url, headers, and json syntax, we should be able to run an Adalo Custom Action on any user action, sending data to GSheets.

6

I feel the simplest way is to use integromat + custom actions

2 Likes
7

the free version of autocode supports 1000 requests per month. Is 1 request equal to 1 cell or column being updated or is it one call to update the data from the entire sheet?