# Connect Google Sheets to Tally and automate your tasks

## Why integrate Google Sheets with Tally

The Google Sheets to Tally integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.

### Log every Shopify order to a Google Sheet automatically

When an order is placed in Shopify, MESA writes the relevant details — customer, line items, order value, fulfillment status — to the right sheet in real time. Your team works from a current, structured record without anyone running manual exports or copying data out of the Shopify admin.

### Build a live ops dashboard your whole team can see

When Shopify order, inventory, and customer events occur, MESA pushes the details to Google Sheets as they happen. Your team tracks what's in motion from a single shared view without digging through the Shopify admin or waiting for a scheduled report.

### Trigger Shopify workflows when a Google Sheet is updated

When a row is added or a value changes in a designated sheet — a product approved, a vendor confirmed, a reorder threshold flagged — MESA kicks off the corresponding action in Shopify. Your spreadsheet-based processes connect directly to your store operations without a manual handoff step between them.

### Turn Tally form submissions into Shopify customer records

When someone fills out a Tally form — an inquiry, an application, a pre-order request — MESA creates or updates their record in Shopify automatically. Your store knows about the customer before they ever place an order.

### Trigger Shopify workflows from form responses

When a Tally submission meets a condition — a product preference, a budget range, a wholesale inquiry — MESA kicks off the right workflow in Shopify. Your forms become the starting point for automation, not just a data collection step.

### Route form submissions to the right person on your team

When a Tally form comes in, MESA reads the responses and sends the details to the right channel — a Slack message, a ClickUp task, an email. The right person gets the context they need without anyone triaging submissions manually.

## Build any Google Sheets and Tally automation

MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running.

###### Form Submitted

Starts when a form is submitted.

###### Row Created

Starts when a row is added to your spreadsheet.

###### Row Updated (Advanced)

Trigger a workflow after each spreadsheet edit. Requires creating an Apps Script in Google Sheets.

###### Get List of Form's Questions

Obtain a list of form's questions.

- ID
- Type
- Title
- Is Title Modified By User
- Form ID
- Is Deleted
- Number Of Responses
- Created At
- Updated At
- Fields

###### Get List of Form's Submissions

Obtain a list of form submissions with their responses.

- Answers
- Response ID
- Form ID
- Submitted At
- Respondent ID

###### Get List of Forms

Obtain a list of forms.

- ID
- Name
- Workspace ID
- Status
- Number Of Submissions
- Is Closed
- Created At
- Updated At

###### Retrieve Form

Grab all details about a form.

- ID
- Name
- Workspace ID
- Status
- Number Of Submissions
- Is Closed
- Created At
- Updated At

###### Retrieve Form Submission

Grab all details about a form submission.

- Answers
- Response ID
- Form ID
- Submitted At
- Respondent ID

###### Add Row

Add a row to an existing Google Sheets document.

- Spreadsheet ID
- Updated Range
- Updated Rows

###### Add Sheet

Add a new sheet to an existing Google Sheets spreadsheet

- Spreadsheet
- Sheet Name

###### Bulk Add Rows

Add multiple rows to a Google Spreadsheet

- Spreadsheet
- Sheet Name

###### Create New Spreadsheet

Create a new Google Sheets spreadsheet.

- Spreadsheet name
- Folder

###### Query Rows

List a selection of rows in a spreadsheet based on a query.

###### Update Row

Modify an existing row in your spreadsheet.