I am trying to sort something that is proving difficult - looking for ideas:
I have an app where the user wants an email every morning, listing jobs that are a certain “status”. I created a new table using a Google Query to pull in all the jobs that are relevant, which is fine.
What I am struggling with is being able to send that data, in an email, for example, once a day. I can use Zapier, and schedule it, which is fine, except I can’t send a BATCH of records, only one new, or updated record. I want to send a list of 100 records… automatically, at, say 6am.