Answered
Automation for Google Drive
One of the manufacturers provides a google sheet as an inventory ( with a public access)
How would you set up an automation for this?
One of the manufacturers provides a google sheet as an inventory ( with a public access)
How would you set up an automation for this?
Hey Erno,
In the connection part of the config, try setting "method" to "GET" and "address" to "https://docs.google.com/spreadsheets/d/<yourkey>/export?exportFormat=csv", and set up the rest of the config as normal.
Let me know if that works, and if it doesn't, if you can provide the link to the spreadsheet, I can try to test locally and provide a working config.
Hi Shivaji,
one of our clients , arrowindustrialsales.com, asked if we can use SD automation to write to a google drive file ( it would be an XLS file, not a CSV)?
Can we use automation to send product data from SD to a google drive XLS file? Is there any specific instructions on this ?
PLease let me know.
Hi Erno,
RE writing XLS file - there is no native support for writing those sheets though you could name the file with .xls extension and will write the csv data to it without issue.
Thanks
Hi Jason, thanks ! I wonder do I change the /export?exportFormat=csv to /import?imortFormat=csv" ?
Currently, for reading from the file, I have /export?exportFormat=csv
for example I can read the file without any problem:
"address":"https://docs.google.com/spreadsheets/d/my_gogole_sheet_id/export?exportFormat=csv"
"name":"MyFIleName - ShopifyDepartmentsLookuplist.csv"
Here the "ShopifyDepartmentsLookuplist" is the tab name in the file.
Not sure - you'll have to consult the google drive documentation.
Reading native xls files works either way.
Great ! Thanks Jason
HI Jason, I was not able to create the connection. I mean in the Google API we gave this:
PUT https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID/values/Sheet1!A1:D5?valueInputOption=VALUE_INPUT_OPTION
How does this translates to SureDone's API
For reading we use GET https://docs.google.com/spreadsheets/d/<yourkey>/export?exportFormat=csv
But where do I plug in the range of values ?
Could you paste how you would do it in CURL - then we can advise how it translates to the Automation config
Hi Jason, I have this; I cannmake it work for SFTP, but not for Google Sheet.
So far I have this:
"connection":{
"type":"http",
"method":"POST",
"address":"https://docs.google.com/spreadsheets/d/My-GoogleSheet_ID/import?importFormat=csv"
}
"file_configs":
{
"name":"Company-SD-Daily-Inventory - InventoryTab.csv",
"search":"(guid:269184 guid:269159)",
"diff_update": 1,
"diff_fields":["stock"],
"field_map":{
"brand":"brand",
"sku":"SKU",
"condition":"condition",
"stock":"stock",
"price":"price"
},
"field_run":{
"brand":"brand",
"sku":"SKU",
"condition":"condition",
"stock":"stock",
"price":"price"
},
"delete_remote_file":0,
"update":"edit"
}
Hi Erno,
Please share how it would work in raw CURL - then we can advise what is missing from the config.
Thanks,
Jason