Google sheet integration with Adalo app

[Sreelakshmi]

Hi, I am very new here and have ‘0’ coding knowledge. I am trying to make an app and want to use google sheet as my database. I saw some related topics here but those are old, so have any new solution for this? i need to integrate google sheets with my App in a very cost effective way.

Thanks in Advance

[dilon_perera]

Welcome to the community @Sreelakshmi!

External connection to Google Sheets directly

Hi @Murali, Welcome to the community Does this error not shows if you try create the external collection after refreshing your tab? I also have tried to connect my sheet directly as a external collection without 3rd parties and the test was successful but unfortunately I only get the valueRanges , Mager Dimension and values as text properties and not return the rows. I think that maybe a JSON format problem. I have contacted Adalo support too and they said that this may will b…

[Sreelakshmi]

@dilon_perera Thanks for your immediate response but i am looking for how to integrate google sheets API with Adalo app without 3rd party integration cost effectively.

[Flawless]

You can’t integrate google sheets api without using it as an external collection unless you have some workaround in like “Make” to pull the data and insert it into your adalo database.

Using Make to sync the sheet data with your database will be more costly than using the google sheets api as an external collection.