• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Workflow: Creating new row with column in Google Sheets for new Shopify orders

Your Task History ID
IjU3NjUwNTZjMDYzZTA0Mzc1MjZlNTUzMjUxMzI1MTY0NTQzNDBmMzgi_pc
Hello,

trying to set up a workflow that adds rows with columns including order information for Shopify orders in a Google Sheet document.

Tried it and got this error:

Task History ID: IjU3NjUwNTZjMDYzZTA0Mzc1MjZlNTUzMjUxMzI1MTY0NTQzNDBmMzgi_pc
Step Name: Google Sheets > Append Values
Connection Name: Google Sheets #2
Task Error Detail:

{
"error > code": 400,
"error > message": "Invalid JSON payload received. Unknown name \"\": Root element must be a message.",
"error > status": "INVALID_ARGUMENT",
"error > details > 0 > @type": "type.googleapis.com/google.rpc.BadRequest",
"error > details > 0 > fieldViolations > 0 > description": "Invalid JSON payload received. Unknown name \"\": Root element must be a message."
}


Could you please help?



What I want to achieve:

Create a new row with columns for order number, customer first name, customer last name, item ordered, customer email, etc. in a Google Sheet document every time a new order is created in the connected Shopify store.

I chose 'append values' since this was recommended (expect the Sheet to quickly reach more than 52 rows).

Thank you.
 
D

Deleted member 15445

Guest
Hello @Andreas.s.

We have checked your issue and it appears that you are entering the values without the double quotes as mentioned in the help text. Please refer to the image attached below,

1734498943815.png


Kindly rectify the mapping and let us know if it works for you.
 

Preeti Paryani

Well-known member
Staff member
Hello @Andreas.s.

Yes, you would have to enter the values without the double quotes as mentioned in the help text.

In Pabbly, double quotes are not added automatically. If the mapped response already includes double quotes, they will appear automatically. Otherwise, you will need to manually add the value within double quotes.
 
T
Hello @Andreas.s.

Yes, you would have to enter the values without the double quotes as mentioned in the help text.

In Pabbly, double quotes are not added automatically. If the mapped response already includes double quotes, they will appear automatically. Otherwise, you will need to manually add the value within double quotes.
Hello @Andreas.s.

Yes, you would have to enter the values without the double quotes as mentioned in the help text.

In Pabbly, double quotes are not added automatically. If the mapped response already includes double quotes, they will appear automatically. Otherwise, you will need to manually add the value within double quotes.
Thank you.
 
Top