# Google Sheets as a Data Source?

**URL:** <https://pug.phocassoftware.com/t/google-sheets-as-a-data-source/2967>\
**Category:** Ask the Community\
**Tags:** erp\
**Created:** [July 31, 2025, 6:15pm UTC](https://pug.phocassoftware.com/t/google-sheets-as-a-data-source/2967 "2025-07-31T18:15:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![edberner](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/edberner/32/114_2.png) [@edberner](https://pug.phocassoftware.com/u/edberner)\
**Post date:** [July 31, 2025, 6:15pm UTC](https://pug.phocassoftware.com/t/google-sheets-as-a-data-source/2967/1 "2025-07-31T18:15:28Z")

</div>

Is it possible to use a Google Sheets document as a Data Source? How do I connect them?

Thanks

---

<div class="post-metadata">

**Author:** ![Jordon](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@Jordon](https://pug.phocassoftware.com/u/Jordon)\
**Post date:** [August 21, 2025, 11:52pm UTC](https://pug.phocassoftware.com/t/google-sheets-as-a-data-source/2967/2 "2025-08-21T23:52:43Z")

</div>

It is technically possible. You can use the [Google Sheets API](https://developers.google.com/workspace/sheets/api/guides/concepts)to download a csv of the spreadsheet and use the sync tool to then upload it to Phocas. If your sheet is publicly accessible via URL it’s a bit easier but much less secure, otherwise you’ll need to add authentication to the script that downloads the file. It’s quite powerful once you get the shell of the script working.

---

<div class="post-metadata">

**Author:** ![edberner](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/edberner/32/114_2.png) [@edberner](https://pug.phocassoftware.com/u/edberner)\
**Post date:** [August 22, 2025, 3:11pm UTC](https://pug.phocassoftware.com/t/google-sheets-as-a-data-source/2967/3 "2025-08-22T15:11:57Z")

</div>

Hi Jordon,

Is it possible to automate uploading the csv spreadsheet to Phocas so that we can sync it automatically every X hours?

I think Phocas should make it easy for people to add new data sources instead of having to rely on technical support. I asked for a quote 2 weeks ago and haven’t got it yet. If adding data sources was as easy as creating reports Phocas would be a lot more useful.

---

<div class="post-metadata">

**Author:** ![Jordon](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@Jordon](https://pug.phocassoftware.com/u/Jordon)\
**Post date:** [August 25, 2025, 12:19am UTC](https://pug.phocassoftware.com/t/google-sheets-as-a-data-source/2967/4 "2025-08-25T00:19:02Z")

</div>

You should be able to upload as much data as you like using [Sync](https://docs.phocassoftware.com/administration/sync)and a Windows scheduled task to trigger your download script and the sync upload. You’ll also need access to the Database Designer to connect the data into the databases.