# Send Dynamic PDFs via DoubleTick WhatsApp Broadcast Using Google Sheets

**Step 1: Install DoubleTick WA Broadcast Extension**

1. Open the Google Sheet containing your customer data.
2. Go to Extensions in the top menu.
3. Click on Add-ons > Get add-ons.
4. In the search bar, type DoubleTick WA Broadcast.
5. Select DoubleTick WA Broadcast and click Install.
6. Once installation is complete, close the add-on pop-up window.\ <br>

   <figure><img src="https://2303112206-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F53n17VnOICC1LtDqlENV%2Fuploads%2FkgVSXgOWyJDUeRGkCFnA%2FUntitleddesign7-ezgif.com-video-to-gif-converter.gif?alt=media&#x26;token=bbb32154-f5d6-4ca6-bf26-c4a2ed59dde7" alt=""><figcaption></figcaption></figure>

**Step 2: Launch DoubleTick WA Broadcast Extension**

1. Go to Extensions in Google Sheets.
2. Select DoubleTick WA Broadcast and click Send WhatsApp Message\ <br>

   <figure><img src="https://2303112206-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F53n17VnOICC1LtDqlENV%2Fuploads%2FcVezvTjhzwwJR2KauzWt%2FUntitleddesign8-ezgif.com-video-to-gif-converter.gif?alt=media&#x26;token=57953da3-b8f2-4df5-ad65-cfc9796935e1" alt=""><figcaption></figcaption></figure>

**Step 3: Configure Message Settings**

1. Select Rows:
   * To send the message to specific rows, choose Select Rows.
   * To send the message to all customers listed in the sheet, select Entire Sheet.
2. Map the Fields: Use the dropdown menus to map each field accurately:
   * Phone Number: Select the column containing customer phone numbers.
   * Customer Name: Select the column with customer names.
   * PDF Column: Select the column where PDF links are stored.

<figure><img src="https://2303112206-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F53n17VnOICC1LtDqlENV%2Fuploads%2FLdXrNGW0Jdby2jXEQfma%2FUntitleddesign9-ezgif.com-video-to-gif-converter.gif?alt=media&#x26;token=c37086dc-8260-45b5-a5ac-fbbe414bbda2" alt=""><figcaption></figcaption></figure>

**Step 4: Choose the Message Template and Channel**

1. Select a Template: Choose the template you want to send to your customers from the dropdown.
2. Select Channel: Choose the appropriate channel name to send the message.

**Step 5: Send the Message**

1. After configuring all the options, click Send Message.
2. The DoubleTick extension will start sending personalised WhatsApp messages with the dynamic PDFs attached.

<figure><img src="https://2303112206-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F53n17VnOICC1LtDqlENV%2Fuploads%2F1rTzKMpugLdMiQmWGmKD%2FUntitleddesign10-ezgif.com-video-to-gif-converter.gif?alt=media&#x26;token=ab9055b3-9ffb-4f44-ae52-2864b0bf167b" alt=""><figcaption></figcaption></figure>
