Google Sheets Trigger

The Google Sheets Trigger is like having a smart assistant that watches your spreadsheet 24/7 and automatically starts your workflow whenever something changes. Whether someone adds a new row or updates existing data, this trigger notices and takes action instantly.

Key Features

• Real-Time Monitoring: Continuously watches your spreadsheet for changes
• New Row Detection: Automatically triggers when new rows are added
• Update Tracking: Detects changes to existing row data
• Flexible Polling: Configure check frequency from 1 minute to 1 hour
• Column Mapping: Automatically maps spreadsheet columns to workflow variables
• Previous Value Access: Compare old and new values for updated rows

Configuration

When to Use Google Sheets Triggers

Perfect for:

• Processing new form responses automatically
• Monitoring customer data changes
• Tracking inventory updates
• Managing project status changes
• Responding to team updates in shared sheets

Not ideal for:

• One-time data imports (use Manual Trigger)
• Scheduled report generation (use Schedule Trigger)
• Processing data from other apps (use Webhook Trigger)

How It Works

1. Connect Your Sheet: Tell InditeAI which Google Sheet to watch
2. Choose What to Watch: Pick the specific tab/worksheet to monitor
3. Set Check Frequency: Decide how often to check for changes (every minute, 5 minutes, etc.)
4. Automatic Monitoring: InditeAI checks your sheet regularly and triggers your workflow when it finds changes

Two Types of Changes Detected:

• New Rows: Someone added a new row to your sheet
• Updated Rows: Someone changed existing data in your sheet

Setup Guide

Step 1: Connect Your Google Account

1. Click "Connect Google Sheets" in the trigger settings
2. Sign in to your Google account when prompted
3. Allow InditeAI to access your Google Sheets
4. You're connected! InditeAI can now access your sheets

Step 2: Choose Your Sheet

1. Select Spreadsheet: Pick from the list of your Google Sheets
2. Choose Worksheet: Select which tab/sheet to monitor
3. Check Headers: Make sure your first row has column names (like "Name", "Email", "Status")

Step 3: Set Check Frequency

Choose how often to check for changes:

Example Usage

Customer Support Tickets

New row in "Support Tickets" sheet → Google Sheets Trigger → Send notification to support team

When customers submit support requests via a form, your team gets notified instantly.

Inventory Management

Stock level updated → Google Sheets Trigger → Check if low stock → Order more supplies automatically

When stock goes below a threshold, automatically create purchase orders.

Lead Processing

New lead added → Google Sheets Trigger → AI qualification → Add to CRM → Email sales team

New leads from forms get automatically qualified and assigned to sales reps.

What Data You Get

When changes happen, your workflow receives easy-to-use information:

For New Rows:

// You can use this data in your workflow:
{{sheets_trigger.new_row.Name}}        // "Jane Smith"
{{sheets_trigger.new_row.Email}}       // "jane@example.com"
{{sheets_trigger.new_row.Status}}      // "Active"

For Updated Rows:

// Current values:
{{sheets_trigger.updated_row.Email}}   // "john@newcompany.com"
 
// Previous values (what it was before):
{{sheets_trigger.previous.Email}}      // "john@oldcompany.com"

Node Display

The Google Sheets Trigger shows:

• Sheet Name: Which spreadsheet it's monitoring
• Check Frequency: How often it checks for changes
• Status: Connected, checking, or error
• Last Check: When it last looked for changes
• Changes Found: Count of recent changes detected

Error Handling

Troubleshooting

Not Detecting Changes?

• Check if your Google account is still connected
• Make sure the first row has column headers
• Verify you have permission to view the sheet
• Try a longer check interval (some changes need time to sync)

Common Solutions

• Reconnect Google Account: Click "Connect Google Sheets" again
• Check Sheet Permissions: Make sure the sheet isn't private
• Refresh the Page: Sometimes the connection needs a refresh
• Test with Manual Data: Add a test row manually to see if it triggers

Best Practices

1. Choose the Right Check Frequency

   • Every minute: Only for urgent, real-time needs
   • Every 5-15 minutes: Perfect for most business workflows
   • Hourly: Great for reports and summaries

2. Set Up Your Sheet Properly

   • First row = Headers: Use clear column names like "Name", "Email", "Status"
   • Consistent Data: Keep the same format in each column
   • No Empty Rows: Avoid empty rows in the middle of your data

3. Workflow Tips

   • Test First: Use a test sheet to make sure everything works
   • Handle Both Types: Plan for both new rows and updates
   • Add Error Handling: What happens if the sheet is unavailable?

4. Optimize Performance

   • Use appropriate check intervals based on actual needs
   • Limit the number of columns being monitored
   • Consider archiving old data to keep sheets manageable

5. Security Considerations

   • Only connect sheets you own or have explicit permission to access
   • Be mindful of sensitive data in monitored sheets
   • Review connected accounts periodically

Ready to automate your spreadsheet workflows? Connect your Google Sheet and let InditeAI watch for changes while you focus on more important tasks!