After connecting to ShipStation I can pull data in the API test into the test screen but when it is published and creates the google excel sheet the excel sheets are blank. I am pulling all of the orders without filters via the API request.
ShipStation data pulls successfully when testing, but Google Sheets remain blank after publishing the Zap
Hi
Help us have more context, by posting screenshots with how your Zap steps are outlined and configured in EDIT mode.
Troy,
Thank you so much. Here are my 3 Zap steps. As you can see I am using the API request.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/d5d8312f-eeda-4eeb-99c5-dbba806b5868.png)
I do get test data back when I test it.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/245c3a3a-82a0-44d3-a25a-9045e97cce68.png)
This is my spreadsheet event. It creates the spreadsheet but they are always empty.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/e4d0de35-0346-43e8-a801-6737ff75e805.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/78128329-2e52-426f-a9a3-5be44056b5a7.png)
ShipStation API docs to reference: https://www.shipstation.com/docs/api/orders/list-orders/
Looks like you you have a double // before orders.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2837a6ab-49da-47f1-9a4d-b8087e27b82b.png)
Looks like you need to replace the {vars} with actual values, either static or dynamic from previous steps.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/ce099313-4066-4d1f-94e4-008f36b1ce6f.png)
Hi Troy,
Thanks for noting the double //. I do get test data in the Data Out of the API request even with the double slash before orders. I took it out just to make sure and the data still returns.
I will give the vars dynamic values and see what happens. It just feels like Zapier isn’t dropping the information onto the Google Spreadsheet. Interesting enough it at least creates a new Spreadsheet. I will read up on the Work with Google Sheets in Zaps and see if there is something useful there.
https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps
You are using this Zap action: GSheets - Get Row(s)
That returns row data based on the lookup conditions.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4d6a9025-8921-484d-bbcd-8321b02301e2.png)
If you want to add data to the GSheet, then try using this Zap action: GSheets - Create Row(s)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/15266c5a-4c84-4220-afb5-f5b0c2e67702.png)
Troy,
You nailed it. I had to create the header rows on my first Gsheet and then map the fields from ShipStation to Gsheets. Seems simple enough it was just understanding what the app wanted to do. Thank you for the guidance.
Thanks for following up here to mark the best answer
Please do reach out in the Community again if you need help with anything else in future. In the meantime, happy Zapping!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.