Zapier Guide
Add leads from a google sheet to your Leader campaign
Part 1 – Setting Up Google Sheets
Step 1
Select the “Google Sheets” module and choose trigger event – New or Updated Spreadsheet Row.
Important: Make sure the spreadsheet is empty before proceeding.
Once connected, add a single lead to the sheet. This step is crucial as the webhook will use the data from this row for further processing.
Step 2
Set up your Google Sheets connection and configure the spreadsheet.
Part 2 – Sending the Leads to Leader
step 1
Add the Webhook module and choose Post.
Step 2
Configure the webhook:
URL: Enter the following link: https://www.leader.online/leader/post/post.php
Payload Type: Choose form.
Under the Data section, add the required identification fields (Leader’s campaign number and password):
campaignid– Enter the campaign number as the value.
campaignpass – Enter the campaign password as the value.
Step 3
Add the rest of the data according to the values established in the Leader campaign. Here’s an example of basic fields:
Name: Fname
Phone: Phone
Mail: Email
If for example you do not have an email in the sheet , there is no need to add it at this point.
Select the appropriate values from the form and complete them to “value”.
If there are other fields that appear in your sheet, such as: city, age, etc.
you can add them at this point. (If the fields already exist in Leader, take the field name and use it here. If they do not exist in Leader, they must be created to get a field name.)
Step 4
After setting up both modules, test the webhook to make sure everything is set up correctly and publish the zap.
.
Step 5
After publishing, you can start adding leads to the connected spreadsheet.
Note: It may take a few minutes for the leads to sync with your Leader campaign.
