What's your biggest current challenge? Have your say in Community Polls along the right column.

Adding Rows to a Google Sheet via Flow Not working

Solved

Adding Rows to a Google Sheet via Flow Not working

jgrawrock
Shopify Partner
10 0 1

Hi, 
The goal of this flow is to find orders that haven't been delivered in 15+ Days end up on a google sheet. Attached are screenshots of the setup.Screen Shot 2022-10-26 at 11.22.57 AM.pngScreen Shot 2022-10-26 at 11.32.26 AM.png

Accepted Solution (1)
paul_n
Shopify Staff
1439 157 333

This is an accepted solution.

Sorry for the delay. Initially I didn't notice anything wrong, but I see you are using {{ order.displayAddress }} which is an object not a field and there is no way to just print that out. Try substituting, {{ order.displayAddress.address1 }} to see if it works. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.

View solution in original post

Replies 5 (5)

lilyliward
Shopify Staff
19 1 9

Hi, 

 

Can you please provide more details?

1. What do you mean not working? Are the conditions met? Is there any error messages for the run?

2. Do you have a screen shot of the activity page for the run? 

To learn more visit the Shopify Help Center or the Community Blog.

jgrawrock
Shopify Partner
10 0 1
  1.  No rows are being added to the google spreadsheet is what's not working.
    1. Not getting any error messages for the run
  2. Screen shot included: Screen Shot 2022-10-27 at 8.30.02 AM.png
paul_n
Shopify Staff
1439 157 333

What is in your "Add row to spreadsheet" action?

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
jgrawrock
Shopify Partner
10 0 1

Here are the add to spreadsheet actions:

Screen Shot 2022-10-28 at 11.50.29 AM.png

paul_n
Shopify Staff
1439 157 333

This is an accepted solution.

Sorry for the delay. Initially I didn't notice anything wrong, but I see you are using {{ order.displayAddress }} which is an object not a field and there is no way to just print that out. Try substituting, {{ order.displayAddress.address1 }} to see if it works. 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.