Export to Google Sheets (Direct)

This method works if you want to export data into a Google Sheet which has other information.

Make sure you have Created an Export first.

---

1. Go to the Sample Screen of your chosen export

This can be found by pressing the pen icon on the Exports screen

2. Click on Spreadsheet Import

3. Click on G Sheets

4. Copy the code by clicking the clipboard

5. In your chosen Google Sheets, click on Extensions

6. In the Dropdown, click on Apps Script

7. In the Code.gs file, paste the code

8. Be sure to save it

9. Test the code by clicking the Play Arrow

10. You will see the Execution Log shows when the script runs

11. G Sheets will update with your data

12. Back in App Script, click Triggers

(To enable scheduled imports)

13. Click on Add Trigger

14. Change event source to Time-driven

15. Click Save

16. Your sheet will have scheduled updates

This is a great free way to have a scheduled backup of your data