# Google sheet integration with Adalo app

**URL:** <https://forum.adalo.com/t/google-sheet-integration-with-adalo-app/49985>\
**Category:** Database\
**Created:** [September 23, 2024, 1:14pm UTC](https://forum.adalo.com/t/google-sheet-integration-with-adalo-app/49985 "2024-09-23T13:14:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sreelakshmi](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@Sreelakshmi](https://forum.adalo.com/u/Sreelakshmi)\
**Post date:** [September 23, 2024, 1:14pm UTC](https://forum.adalo.com/t/google-sheet-integration-with-adalo-app/49985/1 "2024-09-23T13:14:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [September 23, 2024, 1:28pm UTC](https://forum.adalo.com/t/google-sheet-integration-with-adalo-app/49985/2 "2024-09-23T13:28:37Z")

</div>

Welcome to the community @Sreelakshmi! 🥳

> [@External connection to Google Sheets directly](https://forum.adalo.com/t/external-connection-to-google-sheets-directly/29533/2):
>
> Hi @Murali, Welcome to the community partying_face 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…

---

<div class="post-metadata">

**Author:** ![Sreelakshmi](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@Sreelakshmi](https://forum.adalo.com/u/Sreelakshmi)\
**Post date:** [September 23, 2024, 1:34pm UTC](https://forum.adalo.com/t/google-sheet-integration-with-adalo-app/49985/3 "2024-09-23T13:34:30Z")

</div>

@Dilon 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.

---

<div class="post-metadata">

**Author:** ![Flawless](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/flawless/32/20131_2.png) [@Flawless](https://forum.adalo.com/u/Flawless)\
**Post date:** [September 23, 2024, 3:23pm UTC](https://forum.adalo.com/t/google-sheet-integration-with-adalo-app/49985/4 "2024-09-23T15:23:02Z")

</div>

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.