How to schedule data imports using triggers in Google Sheets

[prokopetsv]

Hi there! 👋

If the connector you're using doesn’t offer built-in scheduling, you can still automate data imports using a time-driven trigger in Apps Script.

Here’s how:

1. In your Google Sheet, go to Extensions → Apps Script.

   

2. Click the clock icon in the left sidebar to open Triggers, then click Add Trigger.

   

3. Configure the Trigger:

   • Choose the function to run: importNewData
   • Set the event source to: Time-driven
   • Select the frequency (e.g., hourly, daily)
   • Click Save

   

Your data will now import automatically based on the schedule you set.

[teerantado]

Please help!
I can run manualy
But can not run using trigger

[prokopetsv]

@teerantado Hello! Thanks for the screenshot. I would like to note that AppScript connectors are provided as-is. All code is open, and you can modify your connector locally to address the issue. If you depend on our team for ongoing maintenance, please create the connector from Facebook Marketing in either the self-hosted or cloud version. There is also a feature for triggers.

Please let me know if you have any questions during the process.