Document automator setup guide

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.

    Document automator at a glance

    Document automator triggers and actions

    Airtable automations are made up of a mixture of triggers and actions. Each automation includes:

    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.

    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.

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

    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.

    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.

    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.

    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.

    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.

    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.

    As you can see in the highlighted boxes:

    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: