Google Sheets API External Collection

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

1 Like

Try through sheetdb

2 Likes

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/

1 Like

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.

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

1 Like