Google Sheet Broadcast
Google Sheet Broadcast allows you to send personalized campaigns using customer data stored in a connected Google Sheet. You can map customer details, select message templates, configure retries, and track campaign delivery and engagement.
How It Works
Create a Google Sheet Broadcast
Click Campaign in the left sidebar to access campaign management tools.
Click Add Campaign to create a new broadcast.
Select Google Sheet Broadcast to start configuring your campaign.
Enter a name in the Campaign Name field.
Connect Your Google Account
Before configuring the campaign, create a Google Sheet connection in the Ownchat app.
Open the app connections section and search for Google Sheet.
Click Connect on the Google Sheet card.
Click + Add a New Connection to create a new connection.
Select your Google account and complete the authorization process.
If prompted, click Advanced, select Go to ownchat.app (unsafe), and click Continue to grant access.
Enter a name in the Connection Name field.
Click Create connection to save the connection.
Configure the Spreadsheet
Return to your Google Sheet Broadcast campaign.
Select the connected account from the Google Account Connection dropdown.
Choose the required connection, such as Media Ownchat sheet connection.
Select the spreadsheet from the Select Spreadsheet field.
Choose the required spreadsheet, such as Customer data.
Select the appropriate tab from the Sheet / Tab Name dropdown, such as Sheet1.
Click Fetch Sheet Headers & Data to load the spreadsheet columns and rows.
Select the Phone Number Column dropdown and map the Phone number column.
Under Customer Name Column, select Name to map the customer names.
Select and Personalize the Template
Click Select Template to choose a message template.
Select the t19_deepavali_store_tim template using its checkbox.
Click Next to proceed with the selected template.
Use the Select Value dropdowns to map the required template variables to spreadsheet data.
For the second variable, select Use Fallback Value if you want to provide default content when the variable is unavailable.
Click Select to confirm the template configuration.
Configure Advanced Settings
Click Advanced Settings to configure bot replies, retry attempts, and fallback options.
Click Select Tags to categorize your campaign.
Enter a tag in the Type and press enter to add tags field.
Select the required tag, such as Googlesheet123testing, and click Add to apply it.
Assign Bot Replies
Enable the Assign replies to the checkbox and select Assign replies to the bot to route incoming responses to a selected bot for three days.
Configure Automatic Retries
Enable Retry sending messages to contacts that failed to receive them to retry failed message deliveries automatically.
Configure the retry delay using the dropdown next to the After field under 1st Attempt.
Click the plus (+) icon to add another retry attempt.
You can configure a maximum of three retry attempts.
Send or Schedule the Campaign
Select Send Now to send the campaign immediately.
Alternatively, select Schedule Now to schedule the campaign for a preferred date and time.
Click the Select date and time field and choose the required date and time.
Click OK to confirm the schedule.
Click Create Campaign to finalize and create your broadcast.
Monitor Google Sheet Campaign
Click View Details on the campaign card to review its performance and settings.
You can monitor the campaign using the following options:
Refresh: Click the refresh icon to reload the latest campaign details. Updates may take up to five minutes.
Refresh data: Update the campaign metrics.
Delivery & Engagement Metrics: Review sent, delivered, read, and failed message counts.
Auto-Retry Campaigns: Review scheduled retry attempts for undelivered messages.
If the latest campaign details are not available immediately, wait up to five minutes and click the refresh icon again.
Summary
Google Sheet Broadcast allows you to:
Connect your Google account to OwnChat.
Select a spreadsheet and the required sheet tab.
Fetch spreadsheet headers and data.
Map phone numbers and customer names.
Personalize messages using spreadsheet variables and fallback values.
Organize campaigns using tags.
Assign incoming replies to a bot for three days.
Configure up to three automatic retry attempts.
Send campaigns immediately or schedule them for later.
Monitor delivery, engagement, and automatic retry details.
This completes the Google Sheet Broadcast setup and monitoring process in Ownchat.
Last updated