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

[Andreas.s.]

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.

 

[Deleted member 15445]

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,

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

 

[Andreas.s.]

You mean place each value in quotes?

In my other flows Pabbly did this automatically.

 

[Preeti Paryani]

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.

 

[Andreas.s.]

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.