How to create products from google sheets to shopify with send all data

Status: Closed · Asked by bliang on · 0 views

bliang — Question ·

I was able to add a single row as a new product from google sheets to Shopify without a problem by following the tutorial. However, I am unable to add multiple rows (multiple products) from google sheets to Shopify in one shot. Would someone share his experience on this topic? Thank you!

Arshita — Reply ·

Hey @bliang

It is possible to add multiple products from your Google sheet and subsequently send them all to Shopify.
To accomplish this, you need to first select "Schedule" in the Trigger step of your automation, followed by adding "Google sheet > Get rows" in the Action step, and then finally selecting Shopify as the destination.

To facilitate this process, we have provided a video tutorial for your reference. In this tutorial, you can follow the steps outlined, and instead of the final step, which pertains to a different integration, you would simply add Shopify as the last step to send your data.

youtube.com/watch?v=3ZixI8a3XC4

Do let us know if you get stuck in any step, so we can check it for you.

bliang — Reply ·

I used the way you suggested. Only one record was added. Please advise Thank you!

Arshita — Reply ·

Kindly provide us with your email address linked to your Pabbly Connect account.
Also, the workflow name in which you are getting a random date issue so we can check on it and guide you further.

bliang — Reply ·

[email hidden], "Create Products from Google Sheets to Shopify"

Arshita — Reply ·

Upon reviewing your workflow, we have observed that you have not included the "Schedule" by Pabbly as a trigger event. In order to proceed with the desired task, we kindly request you to delete the Google Sheets from the trigger and add the Scheduler as the trigger event in your workflow. Once this has been done, you can proceed to add the Google sheet as the action step.

To gain a better understanding of how the Pabbly schedule works, we recommend referring to the video tutorial provided below.

(Watch the first part of the video)

youtube.com/watch?v=N2mPQW8O2Pk

Back to all forum threads · Log in to reply