Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Track All Your Shopify Products Directly in Google Sheets

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Shopify Integration

To track all your Shopify products directly in Google Sheets, you first need to set up Pabbly Connect. Begin by visiting the Pabbly website and signing in to your account. If you don’t have an account yet, you can create one for free.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you’ll find options to create a new workflow. Click on the ‘Create Workflow’ button and name your workflow something like “Shopify to Google Sheets” to easily identify it later.

2. Setting Up Shopify in Pabbly Connect

In this step, you will configure Shopify within Pabbly Connect. Start by selecting Shopify as your trigger application. You will need to choose the trigger event, which in this case is “New Product”. This ensures that every time a new product is added in Shopify, it will trigger the workflow.

Select the trigger event as “New Product”.
Connect your Shopify account by providing the necessary API credentials.
Test the connection to ensure everything is set up correctly.

After successfully connecting Shopify to Pabbly Connect, you can now proceed to capture the product details. This will allow you to automatically send the product information to Google Sheets whenever a new product is created in Shopify.

3. Setting Up Google Sheets in Pabbly Connect

Now that you have Shopify set up, the next step is to configure Google Sheets to receive the product data using Pabbly Connect. Choose Google Sheets as your action application. You will select the action event as “Create Spreadsheet Row”.

Next, you will need to connect your Google account to Pabbly Connect. Ensure you allow access to the necessary permissions for Pabbly to create rows in your Google Sheets. Once connected, you can select the specific Google Sheet where you want the product details to be recorded.

4. Mapping Data from Shopify to Google Sheets

With both Shopify and Google Sheets configured, it’s time to map the product data. In this section, you will link the fields from Shopify to the corresponding columns in Google Sheets using Pabbly Connect. This ensures that the correct data is sent to the right places.

Map the product name from Shopify to the first column in Google Sheets.
Link the product description to the second column.
Ensure the price and quantity fields are also mapped correctly.

After mapping the data, you can test the workflow. This will allow you to verify that the data flows correctly from Shopify to Google Sheets through Pabbly Connect.

5. Finalizing the Integration and Testing

Once you have set up the mapping, the final step is to test the integration. Trigger a new product creation in Shopify and check if it appears in your Google Sheets. This is done seamlessly through Pabbly Connect, ensuring that your product data is always up-to-date.

After testing, you can activate the workflow in Pabbly Connect. This will allow the integration to run automatically in the background. You can also explore additional automations that can be created using Pabbly Connect to enhance your workflow.

Conclusion

In summary, using Pabbly Connect allows you to easily track all your Shopify products directly in Google Sheets. This integration not only saves time but also ensures that your product data is always current and accurate.