You can use this Google Apps script as an example how to overwrite the Sheetgo header and use your own header. To customise the script, open the Google Sheets and go to Tools > Script Editor. You need to set the trigger for this script to run when the data in the sheet changes. Then the script below runs and overwrites the headers coming in from the source file. So everytime the sheet updates from a Sheetgo connection, the specified header rows range get the names in the range set values statement after the update.
Articles in this section
- How can I use Sheetgo to merge data from two or more sheets into a single sheet?
- Transfer specific rows
- After making the payment, how do I start to use my license?
- What is the duration of the license? Is there an expiration date?
- How can I get more updates? How can I get more free updates?
- Can Sheetgo access my data?
- Can I lock imported sheets?
- Help me, Sheetgo fails to work!
- What are all the features of Sheetgo?
- How do I manually run a connection?