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.
Answer
ShipStation data pulls successfully when testing, but Google Sheets remain blank after publishing the Zap
Best answer by Troy Tessalone
You are using this Zap action: GSheets - Get Row(s)
That returns row data based on the lookup conditions.
If you want to add data to the GSheet, then try using this Zap action: GSheets - Create Row(s)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
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.
I do get test data back when I test it.
This is my spreadsheet event. It creates the spreadsheet but they are always empty.
+14- Zapier Orchestrator & Solution Partner
ShipStation API docs to reference: https://www.shipstation.com/docs/api/orders/list-orders/
Looks like you you have a double // before orders.
Looks like you need to replace the {vars} with actual values, either static or dynamic from previous steps.
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
+14- Zapier Orchestrator & Solution Partner
- Answer
You are using this Zap action: GSheets - Get Row(s)
That returns row data based on the lookup conditions.
If you want to add data to the GSheet, then try using this Zap action: GSheets - Create Row(s)
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.
+11- Community Manager
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.