> For the complete documentation index, see [llms.txt](https://docs.ownchat.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ownchat.app/campaign/google-sheet-broadcast.md).

# 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.

{% embed url="<https://app.supademo.com/demo/cmvqn2p7210jmqm53h28hoffs?utm_source=link>" %}

### How It Works &#x20;

#### Create a Google Sheet Broadcast &#x20;

1. Click Campaign in the left sidebar to access campaign management tools.

{% embed url="<https://app.supademo.com/demo/cmvrzy9kq04opxj0i8tinelgm?utm_source=link>" %}

2. Click Add Campaign to create a new broadcast.

{% embed url="<https://app.supademo.com/demo/cmvs060o301aw1l0jrazchdp2?utm_source=link>" %}

2. Select Google Sheet Broadcast to start configuring your campaign.

{% embed url="<https://app.supademo.com/demo/cmvs077n60041zc0jj5j50lfz?utm_source=link>" %}

3. Enter a name in the Campaign Name field.

{% embed url="<https://app.supademo.com/demo/cmvs08p9p04quxj0ikt6v7jrg?utm_source=link>" %}

#### Connect Your Google Account &#x20;

Before configuring the campaign, create a Google Sheet connection in the Ownchat app.

{% embed url="<https://app.supademo.com/demo/cmvs0a94z03f71a0ji5cz0dyf?utm_source=link>" %}

1. Open the app connections section and search for Google Sheet.

{% embed url="<https://app.supademo.com/demo/cmvs0bnk703i81a0jtpc3b950?utm_source=link>" %}

2. Click Connect on the Google Sheet card.

{% embed url="<https://app.supademo.com/demo/cmvs0cx0e044muv0jmod50583?utm_source=link>" %}

3. Click + Add a New Connection to create a new connection.

{% embed url="<https://app.supademo.com/demo/cmvs0yugu04upxj0i0okaidaj?utm_source=link>" %}

4. Select your Google account and complete the authorization process.

{% embed url="<https://app.supademo.com/demo/cmvs116if04urxj0i2xrgie3g?utm_source=link>" %}

If prompted, click Advanced, select Go to ownchat.app (unsafe), and click Continue to grant access.

{% embed url="<https://app.supademo.com/demo/cmvs1d7720475uv0jqw3atggc?utm_source=link>" %}

5. Enter a name in the Connection Name field.

{% embed url="<https://app.supademo.com/demo/cmvs39jpb03t41a0je5tavc9q?utm_source=link>" %}

6. Click Create connection to save the connection.

{% embed url="<https://app.supademo.com/demo/cmvs3d5p3051vxj0iq99zhu13?utm_source=link>" %}

#### Configure the Spreadsheet &#x20;

1. Return to your Google Sheet Broadcast campaign.
2. Select the connected account from the Google Account Connection dropdown.

{% embed url="<https://app.supademo.com/demo/cmvs3eqlc0521xj0i7bj4judv?utm_source=link>" %}

3. Choose the required connection, such as Media Ownchat sheet connection.

{% embed url="<https://app.supademo.com/demo/cmvs3kghb01j41l0jqbvjnmss?utm_source=link>" %}

4. Select the spreadsheet from the Select Spreadsheet field.

{% embed url="<https://app.supademo.com/demo/cmvs3luyz03w81a0jvu6o23xh?utm_source=link>" %}

5. Choose the required spreadsheet, such as Customer data.

{% embed url="<https://app.supademo.com/demo/cmvs3nb2x03wa1a0jp4dvejjd?utm_source=link>" %}

6. Select the appropriate tab from the Sheet / Tab Name dropdown, such as Sheet1.

{% embed url="<https://app.supademo.com/demo/cmvs3oido03wc1a0j7zvvmkbs?utm_source=link>" %}

7. Click Fetch Sheet Headers & Data to load the spreadsheet columns and rows.

{% embed url="<https://app.supademo.com/demo/cmvs3put200n9zc0jprx1g7g7?utm_source=link>" %}

8. Select the Phone Number Column dropdown and map the Phone number column.

{% embed url="<https://app.supademo.com/demo/cmvs3sxif01jt1l0jbwoc7015?utm_source=link>" %}

9. Under Customer Name Column, select Name to map the customer names.

{% embed url="<https://app.supademo.com/demo/cmvs3u5c704diuv0j39tm3btk?utm_source=link>" %}

#### Select and Personalize the Template &#x20;

1. Click Select Template to choose a message template.

{% embed url="<https://app.supademo.com/demo/cmvs3vhch00ndzc0jck3xow8v?utm_source=link>" %}

2. Select the t19\_deepavali\_store\_tim template using its checkbox.
3. Click Next to proceed with the selected template.

{% embed url="<https://app.supademo.com/demo/cmvs3wut6053cxj0imwwzbmwg?utm_source=link>" %}

4. Use the Select Value dropdowns to map the required template variables to spreadsheet data.
5. For the second variable, select Use Fallback Value if you want to provide default content when the variable is unavailable.

{% embed url="<https://app.supademo.com/demo/cmvs410vc053exj0i2wihhky6?utm_source=link>" %}

6. Click Select to confirm the template configuration.

{% embed url="<https://app.supademo.com/demo/cmvs44c8h00nzzc0jq2pwfx3k?utm_source=link>" %}

#### Configure Advanced Settings &#x20;

1. Click Advanced Settings to configure bot replies, retry attempts, and fallback options.

{% embed url="<https://app.supademo.com/demo/cmvs47a7c00o1zc0j96x1gnee?utm_source=link>" %}

2. Click Select Tags to categorize your campaign.

{% embed url="<https://app.supademo.com/demo/cmvs4brxf005ozn0j23d59j2q?utm_source=link>" %}

3. Enter a tag in the Type and press enter to add tags field.
4. Select the required tag, such as Googlesheet123testing, and click Add to apply it.

{% embed url="<https://app.supademo.com/demo/cmvs4dbc1005qzn0jljj5jjlb?utm_source=link>" %}

**Assign Bot Replies** &#x20;

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.<br>

{% embed url="<https://app.supademo.com/demo/cmvs4fyhy005szn0jabbkr4st?utm_source=link>" %}

**Configure Automatic Retries** &#x20;

1. Enable Retry sending messages to contacts that failed to receive them to retry failed message deliveries automatically.

{% embed url="<https://app.supademo.com/demo/cmvs4mqn404miuv0j3vzubpv6?utm_source=link>" %}

2. Configure the retry delay using the dropdown next to the After field under 1st Attempt.

{% embed url="<https://app.supademo.com/demo/cmvs4odbb00q1zc0jhvkl8fc2?utm_source=link>" %}

3. Click the plus (+) icon to add another retry attempt.

{% embed url="<https://app.supademo.com/demo/cmvs4pu0s054vxj0ia7m2ootq?utm_source=link>" %}

You can configure a maximum of three retry attempts.

#### Send or Schedule the Campaign &#x20;

1. Select Send Now to send the campaign immediately.

{% embed url="<https://app.supademo.com/demo/cmvs4rflq045r1a0j3uix2pcw?utm_source=link>" %}

2. Alternatively, select Schedule Now to schedule the campaign for a preferred date and time.

{% embed url="<https://app.supademo.com/demo/cmvs4swt2056bxj0imwz4nm2c?utm_source=link>" %}

3. Click the Select date and time field and choose the required date and time.
4. Click OK to confirm the schedule.

{% embed url="<https://app.supademo.com/demo/cmvs4u8dy00s5zc0jkomvije9?utm_source=link>" %}

5. Click Create Campaign to finalize and create your broadcast.

{% embed url="<https://app.supademo.com/demo/cmvs4w0dj04msuv0jpkk1q2fu?utm_source=link>" %}

#### Monitor Google Sheet Campaign &#x20;

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.

{% embed url="<https://app.supademo.com/demo/cmvt0pw5e00032i0j0mjwaiuq?utm_source=link>" %}

* Delivery & Engagement Metrics: Review sent, delivered, read, and failed message counts.

{% embed url="<https://app.supademo.com/demo/cmvt0ro8h014u2q0jz2xienh4?utm_source=link>" %}

* Auto-Retry Campaigns: Review scheduled retry attempts for undelivered messages.

{% embed url="<https://app.supademo.com/demo/cmvt0su4o015b2q0j7fpcn9r8?utm_source=link>" %}

If the latest campaign details are not available immediately, wait up to five minutes and click the refresh icon again.

#### Summary &#x20;

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.
