To automate your process even further, you can automatically remove leads from your campaign when you update a row in Google Sheets by setting up a Zapier.
Step 1: Copy Your Zapier API Key from Instantly
In the Classic Frontend
Go to Integrations -> Apps
Copy Zapier API Key
In the New Frontend
Go to the Integrations tab.
Use the search bar in the Apps section to find the Zapier integration
Click "Copy API key"
Step 2: Prepare Your Google Sheet
Before we start the Zap flow, make a new column inside your Google Sheet called "Remove Lead?". This column will be essential as it’ll be the trigger for the flow.
Step 3: Configure Google Sheets Event
In your Zapier account, click on Create new Zap, select Google Sheets, and in the event type, choose Event: New or Updated Spreadsheet Row.
Connect your Google Sheets account by signing in or selecting an already connected account.
Set up the trigger by selecting the spreadsheet and worksheet. For the Trigger Column, we will be using the “Remove Lead?” field.
Test your trigger.
Step 4: Configure Filter Conditions
Click on the "+" button, and select Filter.
Set your filter as the Remove Lead? column from our spreadsheet and the operator as “Text Exactly Matches” and the value as “Yes”.
Test the setup.
Step 5: Configure Instantly Action
Add Instantly and select event: Remove lead from campaign
Select Instantly account or connect it by pasting the Zapier API key.
Select the campaign and the email address from your Google Sheet list.
Step 6: Test and Publish Your Zap
Test the Zap and publish it. You can check the campaign to verify whether the test lead has been successfully removed.
