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

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!

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
br"Deal ID", "User IDs of all owners", "Event Date", "Deal Stage - Name", "Job Number"], r"4157069551", "5078912", "15/02/2021", "Acknowledged & qualified", "E123232"], 2"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!

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 

 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. 

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!

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

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

Hi @adamstanley 

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

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