# Read google gsheet with processing

**URL:** <https://discourse.processing.org/t/read-google-gsheet-with-processing/4340>\
**Category:** Project Guidance\
**Created:** [October 10, 2018, 6:47pm UTC](https://discourse.processing.org/t/read-google-gsheet-with-processing/4340 "2018-10-10T18:47:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dennis](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/dennis/32/1111_2.png) [@Dennis](https://discourse.processing.org/u/Dennis)\
**Post date:** [October 10, 2018, 6:47pm UTC](https://discourse.processing.org/t/read-google-gsheet-with-processing/4340/1 "2018-10-10T18:47:44Z")

</div>

It is possible read google sheet from processing?

---

<div class="post-metadata">

**Author:** ![jeremydouglass](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/jeremydouglass/32/20_2.png) [@jeremydouglass](https://discourse.processing.org/u/jeremydouglass)\
**Post date:** [October 24, 2018, 6:23pm UTC](https://discourse.processing.org/t/read-google-gsheet-with-processing/4340/2 "2018-10-24T18:23:15Z")

</div>

For a single worksheet you can use GSheets \> File \> Download As \> Comma Separated Values (CSV)

Then you can load the gsheet with loadTable to a Table, or with loadStrings if for example you only have one column.

If you want to query the contents of a GSheet over the web then you would need to send network messages from your sketch using the Google Sheets API.

> **[Sheets API  |  Google Developers](https://developers.google.com/sheets/api/)**
>
> The Sheets API gives you full control over the content and appearence of your spreadsheet data.

This is decidedly advanced. It might actually be much easier to have a sync client or automatic task to periodically download your full sheet and load the local copy.

---

<div class="post-metadata">

**Author:** ![Dennis](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/dennis/32/1111_2.png) [@Dennis](https://discourse.processing.org/u/Dennis)\
**Post date:** [October 24, 2018, 6:32pm UTC](https://discourse.processing.org/t/read-google-gsheet-with-processing/4340/3 "2018-10-24T18:32:29Z")

</div>

Thanks jeremydouglass! For my app I need to read in realtime the gsheet, in this days I try your solution… In the meaning time I’m going to study … If I can do it will update!

---

<div class="post-metadata">

**Author:** ![jeremydouglass](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/jeremydouglass/32/20_2.png) [@jeremydouglass](https://discourse.processing.org/u/jeremydouglass)\
**Post date:** [October 24, 2018, 7:00pm UTC](https://discourse.processing.org/t/read-google-gsheet-with-processing/4340/4 "2018-10-24T19:00:17Z")

</div>

Here is a startup tutorial for you. Update with your progress, and good luck!

[https://developers.google.com/sheets/api/quickstart/java](https://developers.google.com/sheets/api/quickstart/java)

---

<div class="post-metadata">

**Author:** ![Dennis](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.processing.org/dennis/32/1111_2.png) [@Dennis](https://discourse.processing.org/u/Dennis)\
**Post date:** [October 29, 2018, 3:58pm UTC](https://discourse.processing.org/t/read-google-gsheet-with-processing/4340/5 "2018-10-29T15:58:08Z")

</div>

Hi, I tryed the GoogleSheet example and it work but is too complex for my to convert in Processing environment… For the moment i will use the last jeremydouglass explained method!