- 06 Jul 2023
- 5 Minutes to read
Document automator setup guide
- Updated on 06 Jul 2023
- 5 Minutes to read
In this article, we guide you through an Airtable automations' workflow that allows you to automatically create documents in Google Docs leveraging the information stored in your Airtable records.
|Plan availability||All plan types/levels|
|Platform(s)||Web/Browser, Mac app, and Windows app|
Automation - A trigger-action workflow that executes a series of steps, often used to take the place of repetitive or tedious work (ex. posting updates, sending messages, etc). All automations include a trigger and at least one action (ex. when a new record is added [trigger], send a message to the assignee [action]).
Creating automated Google Docs in Airtable
Airtable automations can create powerful and custom workflows to help your team better collaborate, communicate, and stay aligned over time.
- Visit your Airtable homepage.
- Create or open your preferred base.
- Click Automations and then choose Generate a weekly digest in Google Docs.
- A new window opens, requiring you to complete additional information.
- Enter a name or description for your automation.
- Enter the necessary information, then click Test step to the left of each trigger or action.
- To enable your automation, toggle OFF to ON.
Document automator at a glance
Airtable automations are made up a mixture of triggers and actions. Each automation includes:
Triggers in Airtable
The At schedule time trigger allows you to choose a date, time, and cadence for your automation.
You can also update the trigger type to another trigger to better meet your base's needs. We recommend completely understanding your goals and reviewing our other triggers before creating or configuring your trigger.
Records in Airtable
The Find records action allows you to locate up to 100 records in the connected base from a specified view or match provided conditions.
Google Docs in Airtable
If you have yet to connect Airtable and Google before, you'll need to complete the authorization steps before moving ahead. Once the two accounts are connected, you can choose a folder in your Google Drive where any docs created in the future will live. If no folder is chosen, the docs will be put into your overarching "My Drive" folder by default.
Next, update the Title and Content sections. In our example, we'll change the title to "Incomplete projects - Actual trigger time."
The Content section allows you to build reusable templates for future automated documents. Start with the document's header and helper text. Currently, the copy is related to the default use case. Adding a bit more context may help readers to better digest the information.
Next, adjust the Grid of records token so that it only inserts the fields from Airtable that are necessary for our weekly team meeting. Start by clicking the dropdown arrow and selecting the Edit token option.
A window opens, allowing you to choose which step the token is coming from. Our example uses the Find records action step to Insert records as a grid or list.
Our example includes the name, due date, category, project lead, and project team fields. Additionally, we want to ensure both the Include link to view and Include link to record options are selected so collaborators can easily navigate back to Airtable to make changes.
At this point, you can add more text, images, or formatting to the document. You could even add additional grid tokens. Additionally, there is one more consideration: portrait or lansdscape.
It's a good idea to use the landscape option if you have more than 5 fields selected in the rendered grid or list token.
You'll now want to test this step of the automation to make sure that the template you've just created in this automation step looks the way you'd like in Google Docs. After testing successfully, you'll see a URL that you can highlight and copy, or just check the Google Drive folder you configured earlier.
As you can see in the highlighted boxes:
- The outline of the document corresponds to the project lead grouping in Airtable.
- There's a helpful header and context for the document.
- There is a rendered grid that only shows the fields we selected in the "Find records" token.
- The arrows in each row link back to the individual corresponding Airtable record.
- The line below each section shows when the document was generated and links back to the Airtable view where the records were rendered from.
Use the accordion format by default. The code to add a new accordion is:
Yes, both types of documents are supported but we currently do not allow the doc being updated to be dynamically set up.
No, currently document automator only works for Google Docs.
If no folder is specified, then the document will be added to the “My Drive” folder in Google.
Data can be sorted in two ways:
- By selecting an existing view with the desired sort in the "Find records" action step.
- Or by creating a new view for the document automator with the sort you prefer; choose that view in the "Find records" step, and the document will inherit the same sorting.