Document automator setup guide
  • 29 Feb 2024
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Document automator setup guide

  • Dark
    Light
  • PDF

Article summary

Plan availability

All plan types/levels  

Platform(s)

Web/Browser, Mac app, and Windows app

Related reading

Airtable terminology

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

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. Airtable automations can create powerful and custom workflows to help your team better collaborate, communicate, and stay aligned over time.

Automatically creating documents

  1. Visit your Airtable homepage.

  2. Create or open your preferred base.

  3. Click Automations and then choose Generate a weekly digest in Google Docs

    1.  A new window opens, requiring you to complete additional information. 

  4. Enter a name or description for your automation.

  5. Enter the necessary information, then click Test step to the left of each trigger or action.

  6. To enable your automation, toggle OFF to ON.

Document automator at a glance 

Document automator triggers and actions

Triggers in Airtable 

Configuring 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

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

Note

While you can create automations that don't use the Find records automation action, the Find records trigger allows for easier formatting of the resulting document. 

Google Docs in Airtable

Connecting to Google and choosing a folder location

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.

Note

It may be a good idea to create a test folder in your Google Drive and connect to that first since you made want to test out the formatting of the created document before turning this automation on.

Updating the document’s title

Next, update the Title and Content sections. In our example, we'll change the title to "Incomplete projects - Actual trigger time.”

6751016972823documentAutomatorTitle06132022.gif

Updating the Content section's copy

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.

6751393455767documentAutomatorContentCopyUpdate06132022.jpg

Note

You can use markdown to further format the content section of the resulting document. You can read more about Markdown in Airtable here.

Editing the “Grid of records” token

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.

6751428284055documentAutomatorEditToken06132022.jpg

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.

Note

If the sorting order of records in the rendered grid or list is important for your workflow, then be sure to find records by view rather than by conditions in the "Find records" action step. Records will then render in the created Google Doc the same way that they appear in the view you selected in the "Find records" action step.

6751756566807documentAutomatorTokenAdjust06132022.gif

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.

6751841414679documentAutomatorIncludeLinks06132022.jpg

Other options and testing

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

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.

6752218678295documentAutomatorTestURL06132022.jpg

6752557868311documentAutomatorCreatedDoc06132022.jpgAs 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.

FAQs

Are both user-created documents and documents created using document automator supported?

Yes, both types of documents are supported but we currently do not allow the doc being updated to be dynamically set up.

Can I use document automator with other services and platforms?

No, currently document automator only works for Google Docs.

Where are documents stored if a Google Drive folder is not selected during the setup process?

If no folder is specified, then the document will be added to the “My Drive” folder in Google.

How do I sort data being pulled in for the grid and list tokens?

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.


Was this article helpful?