Overwrite vs. Append Output Mode

Overwrite vs. Append Output Mode

Last Updated On October 01, 2019

The API Connector add-on for Google Sheets provides two different output modes: overwrite and append. To access, click on the ‘Output options’ button.

api-connector-overwrite-append

Overwrite mode is selected by default. In this mode, the output of your request will appear in cell A1 of your destination tab (“OpenWeatherMap” in this example), overwriting any data that is already there. This mode will also include the headers associated with your data set, in the first row.

Append mode will append results to the first empty row, and won’t print out any headers.

Comments:2

    1. Right, unfortunately I’m not sure how to reliably differentiate between old and new records since this is a generic tool that connects to thousands of different APIs, all with different structures. However, you should be able to get new records by adjusting your URL, since most APIs let you add query strings to retrieve records after a certain ID or date. You can also base your URL on a cell to make these query strings dynamic so you don’t need to manually update your URL each time.

Leave a Reply

Your email address will not be published.