Jan 24, 2019 12:55 PM
Once a week I want to email a report from Airtable to stakeholders (who don’t have Airtable logins). This report is based on rows created in a particular table in the last 7 days. Basically a filtered view of the table. The report could be as text, PDF, Excel or HTML.
I have managed to use Zapier to send some data on a schedule. But the ‘Find record’ zap only seems to be able to find a single record. Ideally I want to be able to send a whole view or block.
Any ideas? This seems like a fairly basic use case.
Jan 24, 2019 01:01 PM
I believe that zapier has a digest app which should do what you are asking for.
Never used it though so am not too sure how to use it.
Jan 24, 2019 01:23 PM
I wasn’t clear what a digest did either. But maybe that will do it. I will investigate. Thanks for the suggestion.
it would be nice if there was a Airtable zap that allowed you to send a view or a block as a PDF. Then you could just email this out once a week.
Jan 19, 2020 04:18 PM
@Andy_Brice1, did you ever figure this out? I’ve been looking for this functionality too!
Jan 20, 2020 12:01 AM
I wrote my own custom program to do it, using their API and the scheduling function on my Mac. It wasn’t trivial.
Oct 22, 2024 07:41 AM
Coming late but if you're looking for a solution, Typeflow can help you easily generate PDFs from Airtable data using Google Docs templates. It's straightforward and efficient.
Feel free to give it a try, and I'd love to hear your feedback! I'm also offering a lifetime plan for early users at just $100.
Feel free to ping me if you're interested or have any questions.