# Google sheets api example

**URL:** <https://forum.adalo.com/t/google-sheets-api-example/317>\
**Category:** Get Help\
**Created:** [February 26, 2020, 5:07pm UTC](https://forum.adalo.com/t/google-sheets-api-example/317 "2020-02-26T17:07:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![arizzi12](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@arizzi12](https://forum.adalo.com/u/arizzi12)\
**Post date:** [February 26, 2020, 5:07pm UTC](https://forum.adalo.com/t/google-sheets-api-example/317/1 "2020-02-26T17:07:04Z")

</div>

anything out there? pls and ty!

---

<div class="post-metadata">

**Author:** ![Lscramjet](https://avatars.discourse-cdn.com/v4/letter/l/b9e5f3/32.png) [@Lscramjet](https://forum.adalo.com/u/Lscramjet)\
**Post date:** [February 26, 2020, 8:52pm UTC](https://forum.adalo.com/t/google-sheets-api-example/317/2 "2020-02-26T20:52:41Z")

</div>

use [http://sheetdb.io](http://sheetdb.io) to create a webhook and send the data from your sheet to adalo with External Collections. If you do not have the pro plan, than use Zapier + Adalo integration and create a scenario to send data from your sheet to Adalo.

---

<div class="post-metadata">

**Author:** ![arizzi12](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@arizzi12](https://forum.adalo.com/u/arizzi12)\
**Post date:** [February 27, 2020, 2:35pm UTC](https://forum.adalo.com/t/google-sheets-api-example/317/3 "2020-02-27T14:35:40Z")

</div>

So i got it to work just using a external api collection (if it doesn’t return data the collection does not save in adalo). The problem i ran into was that the json result was in a such a format that adalo did not see any fields in the result, so it’s just a blob of data that can’t be reference in a component. ☹

---

<div class="post-metadata">

**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:53pm UTC](https://forum.adalo.com/t/google-sheets-api-example/317/4 "2022-01-19T16:53:53Z")

</div>

Have you ever found a solution this? I find it annoying that people are being funneled through a par per use service for something that should be open source.