# How to use Google sheets as external collection for adalo **URL:** \ **Category:** External Collections, Custom Actions & Collections\ **Created:** [June 16, 2021, 1:49pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848 "2021-06-16T13:49:49Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Aspire](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Aspire](https://forum.adalo.com/u/Aspire)\ **Post date:** [June 16, 2021, 1:49pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/1 "2021-06-16T13:49:49Z")
I want to use Google sheets as external collection for Adalo. I know, there are a lot of API service providers but I want to integrate Adalo and Google sheets without any third party API services. Is it possible to make our own api? Or there are any free solutions? ---
**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\ **Post date:** [June 16, 2021, 2:15pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/2 "2021-06-16T14:15:45Z")
Hi Apsire, Welcome to the Community! 🥳 There are some No-code tools that allow you to turn any google sheet into an API. Below are the websites. > **[Google Sheets REST API, connect Google Spreadsheet with your site](https://sheetdb.io/)** > > Use your Google Sheets as a JSON API. Connect Google Spreadsheets to your CRM or any other tool using JSON API and RESTful requests. > **[Sheety - Turn your Google Sheet into an API](https://sheety.co/)** > > Turn any Google Sheet into an API instantly. Power websites, apps, or whatever you like, all from a spreadsheet. ---
**Author:** ![Aspire](https://avatars.discourse-cdn.com/v4/letter/a/ba9def/32.png) [@Aspire](https://forum.adalo.com/u/Aspire)\ **Post date:** [June 18, 2021, 6:07am UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/3 "2021-06-18T06:07:31Z")
Thanks for your reply. But I need to connect without any third party integrations… Is it possible? Can we use adalo collections API to transfer data to google sheets? If possible, how to do that? ---
**Author:** ![patrickgardner2007](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@patrickgardner2007](https://forum.adalo.com/u/patrickgardner2007)\ **Post date:** [January 19, 2022, 4:55pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/4 "2022-01-19T16:55:30Z")
Did you ever get a reply to this? This should be straightforward but everyone is being funneled to [sheetdb.io](http://sheetdb.io) and other pay services ---
**Author:** ![joeydoherty](https://avatars.discourse-cdn.com/v4/letter/j/bb73d2/32.png) [@joeydoherty](https://forum.adalo.com/u/joeydoherty)\ **Post date:** [January 19, 2022, 7:46pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/5 "2022-01-19T19:46:25Z")
Shouldn’t it be possible with some custom Google Scripts to facilitate what sheetDB does instead of having to use a monthly paid service? ---
**Author:** ![Aleloons](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/aleloons/32/24884_2.png) [@Aleloons](https://forum.adalo.com/u/Aleloons)\ **Post date:** [November 28, 2022, 4:01pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/6 "2022-11-28T16:01:09Z")
Is it possible or not? I don’t want to pay 3rd party too. ---
**Author:** ![airf0](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/airf0/32/25044_2.png) [@airf0](https://forum.adalo.com/u/airf0)\ **Post date:** [November 28, 2022, 4:36pm UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/7 "2022-11-28T16:36:12Z")
Yeah would be cool to know ---
**Author:** ![ADLUSR](https://avatars.discourse-cdn.com/v4/letter/a/ecccb3/32.png) [@ADLUSR](https://forum.adalo.com/u/ADLUSR)\ **Post date:** [August 9, 2023, 7:31am UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/8 "2023-08-09T07:31:03Z")
this makes it really complex to start using adalo… ---
**Author:** ![ADLUSR](https://avatars.discourse-cdn.com/v4/letter/a/ecccb3/32.png) [@ADLUSR](https://forum.adalo.com/u/ADLUSR)\ **Post date:** [August 9, 2023, 7:32am UTC](https://forum.adalo.com/t/how-to-use-google-sheets-as-external-collection-for-adalo/13848/9 "2023-08-09T07:32:32Z")
You’ll need to allow SheetDB to: See, edit, create, and delete ALL your Google Sheets spreadsheets… it’s NOT AT ALL the best solution for privacy purposes.