On New Row Google Sheet

Learn how to use the On New Row Google Sheet trigger to automate WhatsApp outreach for spreadsheet-based leads.

On New Row Google Sheet activates whenever a new row is added to a connected Google Sheet. DoubleTick detects the new customer entry and starts a bot journey. Use this trigger when you store leads or registrations in spreadsheets and need WhatsApp automation to begin immediately.

What's covered

• Where to use this trigger

• How to use it in Bot Studio

• Key takeaways

• Frequently asked questions

• Related articles

Where to use this trigger

Use this trigger when:

• Leads are collected in Google Sheets instead of a CRM.

• Customer details are added through forms, registrations, or manual entries.

• You need automatic WhatsApp outreach for each new row.

• You want automation for bulk lead follow-ups.

This is especially useful for webinar signups, event registrations, offline lead entry, or spreadsheet-based sales workflows.

How to use it in Bot Studio

• Open Bot Studio, create a journey, and select On New Row Google Sheet.

• Click Sign in with Google. Use the Google account that stores your sheet, then allow the required permissions.

• Select the Google Sheet from the spreadsheet dropdown.

• Enable Use First Row as Header if your first row contains column names, such as Name, Phone Number, or City.

• Map the customer phone number: select the correct column in Phone Number Field. This step is mandatory.

• Build and publish the journey. For example, connect the trigger to a message action. See How to Set Up Google Sheet Action for the reverse workflow.

After publishing, whenever a new row is added in the sheet, the bot journey runs automatically. For example, a business collects webinar registrations in a Google Sheet. Whenever a new row is added with a customer's phone number, DoubleTick automatically triggers a journey and sends a confirmation template such as "Thank you for registering. We will share the webinar details shortly." This makes sure instant WhatsApp follow-up without manual effort.

Key takeaways

• On New Row Google Sheet triggers automation for new spreadsheet entries.

• Mapping Phone Number Field correctly is mandatory for outreach.

• It is useful for leads managed outside a CRM, such as webinar or event registrations.

Frequently asked questions

Do I need a CRM to use this trigger?

No. This trigger is designed for businesses that manage leads in Google Sheets instead of a CRM.

What happens if I do not map the phone number field?

You must map it. DoubleTick needs the column containing the customer's WhatsApp number.

Why do I need to enable "Use First Row as Header"?

Enabling it helps DoubleTick identify each column by name, such as Name, Phone Number, or City.

What kind of use cases suit this trigger best?

Webinar signups, event registrations, offline lead entry, and spreadsheet-based sales workflows are common use cases.

Related articles

How to Set Up Google Sheet ActionCreate and Manage BotsOn New Lead