How to add Rows to Create Multiple Spreadsheet section

Hi ​@Alison Wheeler 

If you updated your GSheet worksheet, then click the refresh icon left of the magnifying glass.

Looks like your variables mapped from Zap Step 2 Formatter either need to be retested or remapped.

Hi ​@Troy Tessalone 

Thank you will give that a go.

Alison

Happy Monday, ​@Alison Wheeler! 😁
Did refreshing and remapping the fields do the trick, or are you still running into issues? Want to make sure you’re all set, so please keep us posted on how it’s going! 

Hi Sam and Troy

I am so sorry for the late reply, I have been out for a couple of days.

I have remapped and did the refresh button, but it did not add any more rows in section 4.  I need to add in 2 more rows so it will pull the information through that I require.  When I refreshed the screen nothing happened.  

Thanks

Alison

No worries, ​@Alison Wheeler. Sorry to hear it didn’t work as hoped.

Hmm, if that Create Multiple Spreadsheet Rows action didn’t add the right number of rows I’m wondering if the remapped fields didn’t contain the right number of line item values. 🤔

I just used Formatter to create some fake item item data with the same field names as shown in your previous screenshot and mapped them to the fields in a spreadsheet and it was able to create the relevant rows:

When you test the Formatter action in your Zap does it return something like this:

If it’s different can you share a screenshot of what it’s outputting—as well as a screenshot of the setup of that Formatter action? That will help us to determine if there’s the issue is being caused by the set up of the Formatter action. 

Looking forward to hearing from you!

Hi Sam

Thank you for your help.  I am not sure if I am explaining this correctly.  I think the best way for me to do this is create a brand new Zap and see if I get the same issues.  I ran out of rows at the bottom of the zap as highlighted and could not add any more rows as I added data to my sheet.

So I have added Backorder and Allocated to my sheet

But I do not have any rows after InQuarantine for me to add these to my Zap.

I am not sure how you add in rows to add in the data required - hope that makes sense.

Don’t worry if not as I can recreate the Zap and see if I can get that to work.

I do appreciate your help.

Alison

​@Alison Wheeler

Make sure you have selected the correct GSheet spreadsheet and worksheet.

Try clicking the REFRESH icon to see if that will make the additional column fields available.

Ah I see, ​@Alison Wheeler! So the “rows” you’re referring to are the spreadsheet column fields that should be automatically pulled in from the spreadsheet. As you added additional columns after setting up the Zap (and assuming you’ve got the right spreadsheet and worksheet selected) as Troy mentioned, you’ll need to pull in the missing fields by clicking on the refresh icon that appears at the top of the screen.

I’ve highlighted it in the screenshot below to help show which one it is:

Can you give that a try and let us know whether that then loads the missing fields?