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 for it to work for anyone or giving permission to firstname.lastname@example.org to access the file.
3. Enabling Replace all 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 enabled always before Start the Process.