I'm creating a draft email from Sheets, to Gmail, and the gmail fields all come up empty

You can schedule a “cron job” callback using apps like 0CodeKit that allows you to schedule a “callback” to a URL defined in a “Custom Webhook” trigger in another scenario at the exact time you want

You don’t have to use a data store, this is just an example. You can use Google Sheets, Google Calendar, etc.

Alternatively, if you are already using Airtable, you can use an Airtable formula and built-in automation, briefly mentioned here.

Hope this helps! Let me know if there are any further questions or issues.

@samliew