The Destination Setup feature in Sheet Director allows you to specify exactly where imported, synchronized, or processed data should be written in your Google Sheets. Whether you're querying data from an application or synchronizing records, Destination Setup gives you complete control over the target spreadsheet, worksheet, and starting cell.
With flexible destination options, you can organize data efficiently and automate your Google Sheets workflows without manual intervention.
Destination Setup helps you:
Save data to the correct Google Sheets workbook.
Write data to an existing worksheet or create a new one.
Specify the exact starting cell for imported data.
Overwrite or append records based on your requirements.
Organize data across multiple worksheets.
Reuse destination settings for automated services.
Select the sheet where the data needs to be saved.
Mention the required starting cell value.
Select Append Sheet if the output needs to be appended to the existing Spreadsheet.
Switch on Include Header if required.
Switch Clear Sheet before to clear the old sheet data before execution.
Click on the "+" icon to create a new tab.
Click on the refresh icon to refresh the selected spreadsheet.
Mention the required sheet name.
Click on the tick icon to save.
Click on "X" to close the settings.
If the Include Header is switched off it will not add a header to the destination spreadsheet.
If the Clear Sheet is switched off the existing destination sheet data will not be cleared.
To add a new sheet tab
Click the "+" icon to add a new sheet tab.
Mention the required sheet name.
Mention the required starting cell value.
Switch on Include Header if required.
Switch Clear Sheet to clear the old sheet data before execution.
To Append Sheet
Click on Append Sheet if the output needs to be appended to the existing Spreadsheet.
If Append Sheet is selected the Clear Sheet will automatically be switched off.
Sheet Director's Destination Setup feature provides complete control over where your data is stored in Google Sheets. Whether you're importing, posting, or synchronizing data, you can choose the destination spreadsheet, worksheet, starting cell, and write mode to match your workflow.
Combined with Query Services, Bulk Posting, Synchronization, and the Scheduler, Destination Setup helps automate Google Sheets data integration, improve data organization, and simplify business reporting.