Integrate Google Sheets with Shopify Using Pabbly Connect: A Step-by-Step Guide

Learn how to create discount codes in Shopify from Google Sheets using Pabbly Connect. Follow this detailed tutorial for seamless integration. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start creating discount codes in Shopify from Google Sheets, the first step is accessing Pabbly Connect. Navigate to the URL Pabbly.com/connect to reach the Pabbly Connect landing page.

Once there, you have two options: sign in if you are an existing user or click on ‘Sign Up for Free’ if you are new. After signing up, you will receive 100 free tasks to explore the application. Now, let’s sign in to Pabbly Connect to begin the setup.

2. Creating a Workflow in Pabbly Connect

After signing in to Pabbly Connect, you will be directed to the dashboard. Here, click on the ‘Create Workflow’ button. A dialog box will appear, prompting you to name your workflow. For this integration, name it something like ‘Discount Codes from Google Sheets to Shopify’.

• Click on the ‘Create’ button to proceed.
• Select ‘Google Sheets’ as the trigger application.
• Choose the trigger event as ‘New or Updated Spreadsheet Row’.

After setting the trigger, you will receive a webhook URL. This URL will act as a bridge for connecting Pabbly Connect with Google Sheets. Make sure to copy this URL for the next steps.

3. Setting Up Google Sheets with Pabbly Connect

Next, open your Google Sheets where you have the client data. Go to ‘Extensions’, then ‘Add-ons’, and select ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. After installation, refresh the Google Sheets page to ensure the add-on is active. using Pabbly Connect

• Navigate back to ‘Extensions’ and select ‘Pabbly Connect Webhooks’.
• Choose ‘Initial Setup’ and paste the copied webhook URL.
• Set the trigger column to the final data column (e.g., column D).

Click on ‘Send Test’ and then ‘Submit’ to complete the setup. Ensure that the ‘Send on Event’ checkbox is checked to allow the workflow to trigger correctly.

4. Integrating Shopify with Pabbly Connect

Now that Google Sheets is set up, the next step is to integrate Shopify using Pabbly Connect. Click on the next action step and select Shopify as the application. Choose the action event as ‘Create Discount Code’.

To connect Pabbly Connect with Shopify, click on ‘Add New Connection’. You will need your Shopify admin API access token. Log in to your Shopify account, navigate to ‘Apps’, and click on ‘Develop Apps’. Create a new app and set the necessary API access scopes for discounts.

Copy the API access token and paste it back into Pabbly Connect. Enter your Shopify subdomain for the connection.

Once connected, you can create a discount code in Shopify directly from the data in Google Sheets.

5. Sending Email Notifications via Gmail

The final step is to send an email notification to your customers using Gmail through Pabbly Connect. Add another action step and select Gmail as the application. Choose the action event as ‘Send Email’ and connect your Gmail account.

Map the recipient’s email address from the Google Sheets data to the email action in Pabbly Connect. Fill in the subject and body of the email to inform customers about their new discount code.

Set the email subject as ‘Discount Code Released’. Write a personalized message including the discount code.

After setting up the email, click on ‘Save and Send Test Request’ to ensure that the email is sent successfully. This confirms that your integration is complete and functional.

Conclusion

In this tutorial, we explored how to create discount codes in Shopify from Google Sheets using Pabbly Connect. By following these steps, you can automate your discount code creation and notify customers seamlessly. This integration enhances efficiency and improves customer engagement.