theres a schedule trigger. you can set it to run at specific times (daily, hourly, weekly, custom cron expression). timezone is configurable per workflow
for your use case: schedule trigger (daily 8am) > HTTP node to pull API data > loop through results > upsert rows in your table
weve got about 6 scheduled workflows running daily syncs and they hit within a few seconds of the scheduled time