Help

Introducing Document Automator

cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_White
6 - Interface Innovator
6 - Interface Innovator

: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.

32a24de5323bf3e6dc4c4d45f24c8f33d621f826.png

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.

1f24b1fe237d6f9305577728311f89514f4431d8.png

7e7901da5456137a44a90b99121c89c31d72b5d1.gif

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:

  • OKR (objectives and key responsibilities) updates
  • Roadmap updates
  • Campaign performance reports
  • Publishing Retrospectives

What about Interface Designer or Page Designer?

While similar, Interface Designer and Page Designer are meant to accomplish different use cases:

  • Document automator: Point-in-time reports/status updates leveraging Airtable data across multiple records, meant to be communicated to audiences that may/may not live in Airtable (or be close to the work), allowing broad access (ie. Google docs) across the org. This helps with distribution and permissioning issues, as well as facilitating comments and discussions directly on the report.
  • Interface Designer: Live-refreshing dashboards or surfaces for collaboration on live data
  • Page Designer: Visual assets (physical printed page design, mock-ups) based on individual records (like a real estate brief, business card, etc.)

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.

63 Comments
Jack_Manuel
7 - App Architect
7 - App Architect

This looks great! I currently have a very complex combo of scripting app and Zapier to create call sheets for when our crew is on set. Looking forward to digging in to this to see if it can simplify things.

Andrew_Davies
7 - App Architect
7 - App Architect

Oh am I being daft? I can’t see how to. Could this be used to use datetime_format() on a created date for example?

kuovonne
18 - Pluto
18 - Pluto

You cannot use DATETIME_FORMAT in this situation because formula functions can only be used in formula fields.

Currently to get a nicely formatted date/time, you would need to either get the date/time from a record or use scripting.

Keep in mind that you will also need to take timezones into account when generating your nicely formatted date.

Andrew_Davies
7 - App Architect
7 - App Architect

Ahh thanks Kuovonne as always! That makes sense.

Will see if I can write a script.

Thanks again,
Andrew

Karlstens
11 - Venus
11 - Venus

Hey, this looks neat. I’m keen for a solution to invoice generation, as page designer simply doesn’t shrink or grow grids to accommodate record counts with each varying week/month.

Will have a look at Document Automator this evening, thanks!

Joe_Hewes
7 - App Architect
7 - App Architect

I made a very rudimentary invoice which would do the job at a pinch, but lack of formatting capabilities means this wouldn’t really be a great fit for invoices by the looks of it.

Carter_McKay1
5 - Automation Enthusiast
5 - Automation Enthusiast

In my opinion the Page Designer is a better tool than docs but without the ability to automate. The insert as markdown feature (automated docs) is kinda bogus because of the limited Airtable markdown, if the markdown was the same as Github’s I would be fine using it. The best case solution in my mind is an automated Page Designer (either direct interface from automation or save as attachment), the Airtable community forum is full of people who also need this. Is there a reason that you guys decided to integrate Docs instead of integrating Page Designer?

Joe_Hewes
7 - App Architect
7 - App Architect

The created docs don’t seem to maintain the user’s Google Docs default paragraph styles. Any defaults set at Google Docs get wiped out.

Hendrik_Yang
9 - Sun
9 - Sun

This update is super useful for us. Thanks !

ScottWorld
18 - Pluto
18 - Pluto

Yeah, I’m confused about why Airtable didn’t invest more money into improving Page Designer, instead of rolling out another document creator that, in many ways, is more lacking than Page Designer?

Page Designer needs:

  1. Multipage support (for multiple records and/or linked records).
  2. Headers & footers.
  3. Ability to automatically generate PDF files.
  4. Ability to be automated via Airtable’s Automations.