Best answer

How to populate rows in Google Sheet with the same value without using code?

  • 3 October 2019
  • 1 reply
  • 437 views

Userlevel 2
Badge
  • Certified Zapier Expert
  • 6 replies

Hi everyone,

I’m receiving data that is in line item format, and one is just a single value not in line item format, when I write these line-items to google sheets I want each row to contain the value from the single value, not just the first row. How do I do this? And no I do not know how many line items there will be, sometimes one, sometimes 50.

Thanks!


icon

Best answer by AndrewJDavison_Luhhu 3 October 2019, 22:12

View original

1 reply

Userlevel 7
Badge +10

Hi @Vera - welcome to the community.

Luckily, this one is quite simple. If you're using the "Google Sheets -> Create Spreadsheet Row(s)" step, and you map line item fields alongside just a normal text field, the text field will appear on each row that is created, regardless of whether that it is 1, 3, or 50.

Example:

Column A input = [dog,cat,mouse]

Column B input = Hello

Result:

Column A | Column B

dog | Hello

cat | Hello

mouse | Hello

====

Edit: Just had to do this for a client, so here you go:

"Name" & "Type" are line item lists with 3 items in, where as "Order" is just a single text field.

Screen Shot 2019-10-03 at 22.21.38.pngWhen written to Google Sheets, you'll end up with this:

Screen Shot 2019-10-03 at 22.21.58.png



Reply