Add Google Sheets export
Add the Google Sheets export template for exporting data to your Google Spreadsheets via Productsup.
The Google Sheets export lets you send product data to an existing Google Sreadsheets template. You can use a two-dimensional data table, known as a data table sheet, or one worksheet tab per product, known as a single-item sheet.
For more advanced features of what you can do using a spreadsheet, see Add Excel Export.
Set up the Google Sheets export
To use the Google Sheets export with an existing Google Sheets spreadsheet.
Go to Exports from your site's main menu and select Add export. Search for Google Sheets, hover over it, and select Add.
Optionally, give your export a custom name in Name. The custom name replaces the export's name on the Overview page. Then select Add.
On the Exports page, select the name of the added export to set it up.
Select Add Destination and choose Google Sheets API from the dropdown. You can optionally give your destination a title in Name. Then select Save.
In the Authentication selection, select your existing Google Sheets authentication or select Add New Authentication. Then, select Google Spreadsheets from the dropdown. Productsup next redirects you to Google's sign-in for authentication. After authenticating, you return to the Google Sheets API destination to continue with the setup.
In Spreadsheet Name, enter the spreadsheet's name where you want to export your data.
In Sheet Prefix, enter a sheet prefix name, for example,
Sheet 1.Toggle Allow only headers to On, to let the platform send only headers when there is no data to send.
Turn on your export by selecting Active to On.
Select Save.