About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Split items from Googe Sheets Raw Rows

  • 15 February 2021
  • 8 replies
  • 904 views
A
Userlevel 1
Badge

Hi all

I’m using a Google Sheet integration to pull a number of results from Google sheets (Get Many Spreadsheet Rows (Advanced, With Line Item Support)

I’m currently testing with 2 results, which are: 4157069551,4157190930

 

I’d like to get each result as it’s own text field.

To do this, I’m using Utilities > Line-item-to-text

I’m using the ‘Rows’ result from Google sheets in the input which looks like this:

 

I’ve put a comma in the separator box.

 

Here is the output:

 

output

item_1: 4157069551,4157190930

item_2: 4157069551,4157190930

item_last: 4157069551,4157190930

text: 4157069551,4157190930,4157069551,4157190930

 

I’m not sure why both results are showing as a one. Any suggestions to get this to split as item 1 and item 2?

 

thanks

Adam

 

 

 

icon

Best answer by GetUWired 16 February 2021, 20:06

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @adamstanley 

Try one of the other Formatter Utilities options. (e.g. Text to Line Items)

Check out this help article: https://zapier.com/help/create/format/create-line-items-in-zaps

 

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
Userlevel 7
Badge +12

Hi @adamstanley!

 

With line items, the square brackets that it’s a line item within another line item - a nested item.

 

I would take a look at how the data is organized in Google Sheets. To get each number as a line item they will need to be on separate rows, if the sheet is set up like that then the Zap should pull both rows as line items. In the Zap editor, it will look like they are just comma-separated but they’re line items. I hope that helps!

 

A
Userlevel 1
Badge

Thanks both. Here is the info that I get from the ‘Get many spreadsheet rows’ step:

 

rows
 1
  1 Deal ID
  2 User IDs of all owners
  3 Event Date
  4 Deal Stage - Name
  5 Job Number

 2
  1 4157069551
  2 5078912
  3 15/02/2021
  4 Acknowledged & qualified
  5 E123232

 3
  1 4157190930
  2 5078912
  3 15/02/2021
  4 Acknowledged & qualified

raw_rows
[["Deal ID", "User IDs of all owners", "Event Date", "Deal Stage - Name", "Job Number"], ["4157069551", "5078912", "15/02/2021", "Acknowledged & qualified", "E123232"], ["4157190930", "5078912", "15/02/2021", "Acknowledged & qualified"]]

count
3

zap_search_was_found_status
true

Should I just be able to use the Utilities > Line Itemizer (Create/Append/Prepend) to get the specific values from the above?

For the value should I use the ‘Rows’ option or the ‘Raw Rows’ option?

Many thanks!

 

 

GetUWired
Userlevel 7
Badge +12

Hi @adamstanley 

This would be difficult to split with Zapier’s utility functions. The get many spreadsheet rows function returns 1 list with many lists nested inside which Zapier’s utility doesn’t support very easily, as you are seeing.

Usually, to read something like this I would use a code block. or as you are discovering, multiple line item-text actions but it can be confusing.


The best no code solution I have found is to swap out the Get Many Spreadsheet Rows action with a Google Drive Find File action and then use Zapier’s utility to import the CSV version of the file. From there, you can split your line items in another utility.

The above workaround only works if your Google sheet only has 1 worksheet. Here is a demo:

My Test Spreadsheet just for reference

Use the find a file action to retrieve the spreadsheet 

The above will search for the file and return all types of fields but 1 in particular is useful for your scenario.

 Next, use Zapier’s utilities to import the csv file that was returned in the search step. 

You will get back the line items with headers instead of what you were seeing which was a list of all the rows which as you saw Zapier turns into 1 huge list. 

what is returned from the import action.


Since what is returned is a smart list (one with defined headers/(i.e major dimension as columns)) it is more use friendly to continue to work with. From there, you can split your data as it relates to the column it lives under. 

Hopefully that helps!

 

A
Userlevel 1
Badge

Hey @GetUWired 

thanks so much! Really appreciate you taking the time to write this out and with the screenshots. This looks like it’ll work a treat! Thank you!

Adam

A
Userlevel 1
Badge

Hi @GetUWired - thanks again for this suggestion - it works perfectly!

I have another query for you if that’s ok. I’m using the above to pull out the Deal IDs and I then want to create a task on each Deal.

This will run daily. Sometimes there are 1 or 2 deals, but other days there might be up to 10.

Do you have any suggestions of how to ‘Create Engagements’ for multiple deals (each task assigned to different users)? I started by using paths, but Zapier limits to only paths so that only works up to the first 3, but on days when i might have 5 or 6 deals I’m a bit stuck!

Any thoughts or suggestions on how to achieve this?

Thank you!

Adam

GetUWired
Userlevel 7
Badge +12

Hi @adamstanley 

Should the tasks be assigned via a round robin or does a particular task type get assigned to a particular user? 
 

A
Userlevel 1
Badge

Hi @GetUWired 

Thanks! Tasks should be assigned to a specific user. So currently I have a column with Deal IDs and the a column with the Deal Owner User ID.

Just need to crack this ‘looping’ of the creation of tasks

Thanks!

Adam

Terms & Conditions