How to Add Unsubscribed User Details from ConvertKit to Google Sheets Using Pabbly Connect

Learn how to automatically add unsubscribed user details from ConvertKit to Google Sheets using Pabbly Connect. Step-by-step guide for seamless integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add unsubscribed user details from ConvertKit to Google Sheets, first, access Pabbly Connect. Open your browser and navigate to the Pabbly website.

If you are a new user, click on ‘Sign up for free’ to create an account. Existing users can click ‘Sign in’. Once logged in, select Pabbly Connect from the apps section to begin the integration process.

2. Creating a New Workflow in Pabbly Connect

In Pabbly Connect, click on the ‘Create Workflow’ button located at the top right corner. A dialog box will prompt you to name your workflow, so enter a suitable name like ‘Add ConvertKit Unsubscribers to Google Sheets’.

After naming, click ‘Create’. This opens two windows for trigger and action selection. For this integration, choose ConvertKit as the trigger application and Google Sheets as the action application.

3. Setting Up the Trigger with ConvertKit

Now, select ConvertKit as your trigger application in Pabbly Connect. Choose the ‘New Unsubscribe’ event and click ‘Connect’. You will need to create a new connection by providing your API key and API secret from your ConvertKit account.

To find your API details, log into ConvertKit, go to the settings section, and locate the API key and API secret under the ‘Advanced’ tab. Copy these details and paste them into Pabbly Connect. Click ‘Save’ and then ‘Save and Send Test Request’ to confirm the connection.

• Log into ConvertKit and navigate to the settings section.
• Locate your API key and API secret under the ‘Advanced’ tab.
• Copy and paste these details into Pabbly Connect.

Once the test request is successful, proceed to manually unsubscribe a test user in ConvertKit to generate a response in Pabbly Connect.

4. Configuring Action to Add Rows in Google Sheets

After setting up the trigger, the next step is to configure the action. Select Google Sheets as the action application in Pabbly Connect and choose ‘Add New Row’ as the action event. Click ‘Connect’ and authenticate your Google account.

Ensure you are logged into your Google account to facilitate a smooth connection. Once connected, select the Google Sheet where you want to store unsubscribed user details. Map the fields for first name and email using the data received from ConvertKit.

• Select your Google Sheet named ‘ConvertKit Subscribers’.
• Map the first name and email fields using the data from the previous step.
• Click ‘Save’ and send a test request to confirm the setup.

After sending the test request, check your Google Sheet to verify that the unsubscriber’s details have been successfully added.

5. Summary of the Integration Workflow

In this workflow, we utilized Pabbly Connect to automate the process of adding unsubscribed user details from ConvertKit to Google Sheets. The trigger was set to monitor new unsubscribes, while the action added a new row in Google Sheets with the relevant details.

This integration ensures that you can efficiently manage your subscriber list without manual intervention. Every time a user unsubscribes, their details are automatically logged in your Google Sheet, streamlining your workflow.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automatically add unsubscribed user details from ConvertKit to Google Sheets. With this integration, you can maintain an up-to-date record of unsubscribers effortlessly, enhancing your email management process.