Search

Google Sheets Automation

Moxo's integration with Google Sheets streamlines data management by automating tasks such as creating rows or columns in spreadsheets. This integration enhances project management, data syncing, and organization. Follow this guide to set up and trigger Google Sheets automation within a flow workspace.

 

Adding Google Sheets Automation in Moxo

To a Flow Template or Instant Flow

  1. Open the flow builder and navigate to where the automation will be added.
  2. Drag and drop Automations from the left-hand panel under Control, or click the '+' button between actions in the flow and select Automation.





To a Live Flow

  1. Open the relevant flow workspace.
  2. Click the '...' ellipses icon.
  3. Select + Add New Action from the dropdown menu.
  4. Scroll down and select Automations under Control.
  5. Identify where the automation should be added, then click + Add Here.

 

Configuring Google Sheets Automation

Step 1: App and Event Setup

  1. Select Google Sheets as the app.

     

  2. Choose the desired event, such as:
    • Create Spreadsheet Row
    • Create Spreadsheet Column
  3. This event will trigger when the automation is executed.
  4. Click Next to proceed.


Step 2: Account Setup

  1. Click Choose to select an existing Google account you have used in Moxo.



  2. If no account is linked, click + Connect a New Account and follow the prompts to connect a new account.
  3. Once the account is selected, click Next.


Step 3: Input Configuration

  1. Choose the drive containing your Google Sheet and click Next.



  2. Select the spreadsheet where the automation will apply (e.g., creating a new column), and click Next.



  3. Choose the specific sheet within the spreadsheet for the automation, and click Next.



  4. Add a column name manually or use the enhanced DDR feature to autofill names based on previous actions. Click Next.

 

Finalizing the Automation

  1. Review the details for the chosen Google Sheets event (e.g., creating a new column).
  2. Verify the information and click Add Automation to integrate it into the flow.
  3. The Google Sheets automation will now trigger as specified.



Editing the Google Sheets Automation

  1. Navigate to the flow template or live flow workspace containing the automation.
  2. Hover over the automation you wish to modify.
  3. Click the 'Edit' icon.
  4. Adjust the app, event, account, or input fields as needed.
  5. Click Save Changes to apply updates.

Automations can only be edited in saved flow templates or live flow workspaces if the automation is incomplete. Once completed, the automation cannot be reopened or modified.

 

Best Practices

  • Pre-configure accounts and spreadsheets for a smooth setup.
  • Regularly review automations to ensure alignment with project needs.
  • Use DDR to dynamically populate data fields for more efficient automation.