For the Write to Google Sheets connection method, there are few steps involve which are provided below:-
1. Enter the Google Sheet link to retrieve the inventory.
Example: the link will be like this https://docs.google.com/spreadsheets/d/....
*Note: Please change Google permission to "Anyone with the link" for it to work for anyone or giving permission to [email protected] to access the file.
3. Enabling Replace all is defined will clear 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.