Search API Connector Documentation


Set Data Destination

This article will describe how to set a destination sheet and cell in Google Sheets, using the API Connector add-on for Sheets.


Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

How to Set a Destination

API Connector will print data into your sheet starting from the destination Sheet and cell you specify. There are 2 methods of setting a destination cell: manual entry and automatic.

Manual Entry

If you manually enter a Sheet name, it will use that sheet. If that sheet doesn’t exist yet, it will be created when you click Run. By default it will print to cell A1, or you can manually enter a destination cell.


If you click Set Current, it will automatically set your data destination to the currently focused cell in your sheet.

Keep Formulas

All data will be cleared to the right and below the starting cell.

If you are including calculations and formulas, we recommend adding them into columns on the left. Then you can set a destination cell to the right of those formulas, such that they don’t get overwritten.

Overwrite vs Append Mode

When you choose Overwrite mode, the data response will begin from the cell you specify. When you choose Append mode, it will begin from the first empty row. Either way, it will use the column specified in your starting cell input field.

Previous Add Request Body
Next Set Output Mode

Leave a Comment

Table of Contents