Google Sheets as a Data Source?

ERP
1

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

Thanks

1 Like
2

It is technically possible. You can use the Google Sheets API 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.

3

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.

4

You should be able to upload as much data as you like using 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.