I want to automate retrieving new orders from Shopify into Google Sheets. I already have the Sheets tab ready, and the zaps are configured correctly.
I even checked the zap runs and see they are running correctly.
But I still don’t see the data in Google Sheets.
What else could be happening here?
Hi
For us to have more info, post screenshots showing how your Zap step 2 is configured in the CONFIGURE tab with the field mappings visible.
Help links for how to map variables between Zap steps: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields
Check your Zap Runs history to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot: https://zapier.com/app/history/
The GSheet step will return the Row ID that was used for you to check in GSheets.
Hi
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Hi,
It worked, thanks for your help! I have one doubt: when an order comes and it has two different products, they are grouped in the same row like this:
Is it possible to make it print the two products in different rows, like this???
Use this Zap action: GSheets - Create Multiple Spreadsheet Rows
In the same Zap?
Instead of this Zap action: GSheets - Create Row
Use this Zap action: GSheets - Create Multiple Spreadsheet Rows
Oh got it, let me try it. Thanks a lot!
I’m trying to find an option to Create Multiple Spreadsheet Rows on Top but can’t find one. Do you know if that’s possible?
I found an option to create Custom Actions, but it’s struggling to create that specific action.
I used the Create Multiple Spreadsheet Rows option and it created the row on the top, no need for another action. That’s great.
But I still get all product items in the same row like this:
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
Hi
If you're using the "Create Multiple Spreadsheet Rows" action, but encountering an issue where all product items are added to the same row. To fix this, ensure that your data is structured correctly and that you use Zapier's line item support to handle multiple products. Map the line item fields properly and use the line item looping feature to create separate rows for each product. Test your Zap with sample data to verify the results, and if issues persist, review your data structure or contact Zapier Support for more guidance.
Feel free to ask for further assistance if you have any questions or issues.
Hi, got it. I think it worked, I can now see that data in multiple rows. Thanks a lot.
Is it possible to configure that action so that the new multiple rows are added at the top, rather than the bottom? I used an action called Create Spreadsheet Row at Top but that’s only for single items, so what I’m looking for is like a combination of Create Spreadsheet Row at Top and Create Multiple Spreadsheet Rows.
If you want to add rows at the top, then you can use these Zap steps:
Hi,
I haven’t been able to do it :(
What I’ve been getting is either one of the first two results, but I’m aiming for the third result (which I see there’s no direct action for that).
In that third option only one row presents all the basic data like DATE (fecha), ORDER # (#Pedido), FIRST NAME (Nombre), LAST NAME (Apellido), CITY (Municipio), and ZIP CODE (CP).
The data for the products that need their own row are QUANTITY (Cantidad), ITEM (Articulo), and PRICE (Precio).
As you can see, the SHIPPING PRICE (Envio), TOTAL PRICE (Total), and FINANCIAL STATUS (Estatus Pago) are only shown once, since they’re the same for the whole order.
Finally, I’d like that to be returned at the top in each trigger.
I don’t really know if it’s possible, but that’s what I’ve been doing manually for clarity purposes.
Any help is much appreciated.
P.S. Thanks to whoever edited out the personal data on the last image I uploaded, my bad.
A different approach would be to use Airtable instead of GSheets.
Airtable has Table Views, which can be configured to SORT.
So you could have a Table View that auto sorts the data.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.