Google Spreadsheets Connector
- Ben van Klinken
Analytics
The Google Spreadsheets connector allows you to transfer much of your data to a google spreadsheet.
There are several usages for this:
integrations :
- Google Products Search / Google Shopping
- Australia Post / Other postage systems
- http://www.getprice.com.au
- http://www.goshopping.com
- Your own system – just download a text file or csv file from google
You can provide your products to others by publishing the google spreadsheet. You can easily limit the data you export in google spreadsheet
Batch Updates – use the spread sheet connector to make batch changes to your product's pricing, etc.
Auditing – easy backups of your datahub, just copy the spreadsheet file
Testing – easily view what data is in the datahub
Setup instructions:
Spreadsheet Setup
- Go to the following link: https://docs.google.com/spreadsheet/ccc?key=0AlSIPW2fCJnjdDlzREdsb1IxdDJ3V2FKMkc2dFlZdlE#gid=0
- Save the spread as something local (File > Save as)
- Take note of the name you saved the spreadsheet as
- Follow the prompts and use the spreadsheet name that you saved the spreadsheet as previously
Additional instructions:
We apologise, but these instructions are incomplete. Please contact support so we can help you set this connector up.
Google Spreadhsheet Notes
The Google Spreadsheet connector can synchronise the datahub with a google spreadsheet. There are several usages for this:
Other integrations:
- Google Products Search / Google Shopping
- Australia Post / Other postage systems
- http://www.getprice.com.au
- http://www.goshopping.com
- Your own system – just download a text file or csv file from google
- Provide your products to others by publishing the google spreadsheet. You can easily limit the data you export in google spreadsheet
- Auditing – easy backups of your datahub, just copy the spreadsheet file
- Testing – easily view what data is in the datahub
Spreadsheet Setup
- Go to the followinging link: https://docs.google.com/spreadsheet/ccc?key=0AlSIPW2fCJnjdDlzREdsb1IxdDJ3V2FKMkc2dFlZdlE#gid=0
- Save the spread as something local (File > Save as)
- Take note of the spreadsheet key (0AlSIPW2fCJnjdDlzREdsb1IxdDJ3V2FKMkc2dFlZdlE in the above example, but you should use the key of your own copy
- Setup slyncy using the specified key
Notice:
At this stage this connector is flagged as Beta. This means that the connector has only recently been finished.
This basically just means that we will spend some more time with you checking that the setup will work for your scenario before we finalise your configuration.