Write to Google Sheets connection method (Export)
For the Write to Google Sheets (Google Sheets Export) connection method, there are a few steps involved which are provided below:
In the Source Host section, paste the link to your Google Sheet where the inventory details will be exported.
For example, the link will be https://docs.google.com/spreadsheets/d/.....
Important: To protect your Sheets, please grant access to stock-sync@appspot.gserviceaccount.com
Enabling Replace all is defined will clear the google sheet before writing. By default, it is disabled and will not clear the sheet.
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 always enabled before Starting the Process.
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.
In the Source Host section, paste the link to your Google Sheet where the inventory details will be exported.
For example, the link will be https://docs.google.com/spreadsheets/d/.....
Important: To protect your Sheets, please grant access to stock-sync@appspot.gserviceaccount.com
Enabling Replace all is defined will clear the google sheet before writing. By default, it is disabled and will not clear the sheet.
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 always enabled before Starting the Process.
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.
Updated on: 11/03/2025
Thank you!