Write to Google Sheets connection method (Export)

Modified on Tue, 20 Feb at 11:25 PM

For the Write to Google Sheets connection method, there are a few steps involved which are provided below:

1. Enter the Google Sheet link to retrieve the inventory. 

For example, the link will be like this https://docs.google.com/spreadsheets/d/.......

Please change Google permission to Anyone with the link and can edit for it to work for anyone or giving permission to stock-sync@appspot.gserviceaccount.com to access the file.


3. Enabling Replace, all that is defined will clear the Google sheet before writing. By default, it is disabled and will not clear the sheet.


4. By default Create new line is enabled and the new products will be appended as well as updating the existing product. Ensure that Create new line is always enabled before Starting the Process.
 


5. In the Matching Column section of Step 2, only column indexes are supported for export feed, and not column names. Please ensure that using column index (1,2,3) instead of column name.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article