Written By: Marvin Hödlmoser
Last Updated on September 18, 2023
Append rows in Google Sheet with custom columns
In this Tutorial we show how to append rows in a Google Sheet file with a custom column. You could use this tutorial for example if you would like to export your orders to the same Google Sheet file every day with a custom column in the sheet where you write down notes to the orders.
Set the "Export Mode" in the Report Settings to "Incremental" This will cause DataChamp to only export new orders that haven't been exported in a previous run.
Change the "File Type" to "Google Sheets" and select "Append". Now DataChamp will only add new rows without overwrite old ones.
Then you can add your column in the Google Sheet file. Every time DataChamp processes the Shopify data it will only append additional lines and the lines already in the report will keep as you modify them.
You must add the additional columns in DataChamp - only then they will be kept and not overwritten (only new lines with the same empty columns will be appended).