:wave: Hello! I’m Scott – a product manager at Airtable who worked on the development of document automator – the newest way to get Airtable data into formatted documents.
What is document automator?
Available to those on Pro and Enterprise plans, Document automator is a new integration with Google Docs and associated automation action that enables you to export formatted Airtable data directly into Google docs, where you can format and collaborate on that data to your heart’s content.
Furthermore, because document automator is built into automations, you can use other automations like Slack or Email to automatically share the created document with others, fully automating the process of creating and distributing published reports or status updates.
How can I use document automator?
Document automator is perfect for creating point-in-time reports or status updates that can be shared with people who don’t have access to Airtable, when you want to editorialize around the data, or when you want to facilitate feedback and discussion about the data. Common use-cases for document automator include:
What about Interface Designer or Page Designer?
While similar, Interface Designer and Page Designer are meant to accomplish different use cases:
Where can I learn more?
To learn more about how to use document automator, check out the launch blog post, or help center article.
I’ll also be hosting a Community AMA to talk all things content automator on June 29, at 9 am PT where you’ll have the opportunity to see the feature in action and ask any questions you may have. You can register now here, and I can’t wait to see you online.
We can’t wait to see what you create with the document automator and would love to hear your thoughts below.
If you are on a pro or enterprise plan and not seeing these changes reflected in your workspace, try clearing your cache.
Thank you for telling us about this new features.
It looks like you create the entire body of the document in the “Content” section of the automation. Thus, it looks like it is not possible to use an existing Google Doc as a template. Is this correct?
What about configuring other aspects of the doc (page numbers, page size, headers/footers, margins, etc.)?
Does this mean that the rollout to all pro & enterprise users is complete?
Oohhhh. This looks interesting.
Though it would have to be very good to stop me from using On2Air’s excellent actions that creates a PDF from a set of records and attaches it back to the record itself.
Without the ability to sort record lists/grids in automations, I’m not really able to use this feature.
For example: I want to produce a check-in list for front desk staff to sign in event attendees. I can query for RSVPs by event, but unless I can also sort that list by last name, it’s effectively useless.
I think this is fab. I have a Master Budget table with rollups from a transactions table (see attached)
I have wanted to show our FD a weekly report so we can track changes - this is perfect for that! Took all of 5 mins to set up too.
Quick question - is it possible to format the date? I have inserted the triggered date - but can’t see how to apply a datetime_format to it. It currently shows as 2022-06-14T19:38:53.173Z
Now just seeing if I can get Integromat / make to automatically generate it as a PDF - my FD hates Google Docs!
I see that editing the tokens in automations steps is new, or at least new to me. Super useful.
For the Create Doc step it would be great if in addition to “Content” section there was a Header and Footer.
I agree. Hopefully we will soon see this feature in email automations.
It is possible to achieve what you describe by taking the following steps:
Hope that helps!
I can edit and modify tokens placed in the Email actions. Maybe “old” tokens can’t be edited, but newly inserted one can
I mean, this is whatever. At first glance, it seems somewhat ridged. I don’t see much flexibility when juxtaposed with other third party solutions which aim to address a similar function. EG documint
This is a great workaround, however I must point out that if you are creating, for instance, and Invoice doc that inserts the line item records as a grid, you can’t do this. Because you will need to use “filter by condition” to pick the line items linked to the appropriate “invoice”. That eliminates your ability to sort.
You could as an alternative use a Run a Script action to sort/filter your records but then you can’t insert them as a grid.
At present there isn’t a great solution for sorting records in an Automation when you need to filter by condition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.