Google Sheet List Type Mismatch

Get Help Pipeline Failure
1

I’m trying to create a flow that automatically fills in company website URLs in my Google Sheets. Here’s my current setup:

  1. Google Sheets Reader - reads company names from the sheet
  2. Search Companies - searches for company websites (settings: Input: ‘company name’, Company Information: ‘websites’, # of Results: 1)
  3. Get List Item - tries to get the first element from the list (index: 0)
  4. Error Shield - added for protection
  5. Google Sheets Writer - tries to write the found URLs to the sheet (Writer Mode: Add A Single New Row)

Problem:
I’m getting a type mismatch error (Types do not match! List/single value) when connecting between nodes. I’ve tried different combinations of enabling/disabling Loop Mode in the nodes, but the problem persists.

Can someone help me resolve this type mismatch issue? I need to properly connect these nodes to automatically fill website URLs in my Google Sheet.

Thank you in advance!

2

Results 1 doesn’t work for evading the problem of mismatch error. You need a flatten list I think as well. @Wasay-Gumloop correct?

3

Here is the link to workbook
https://www.gumloop.com/pipeline?workbook_id=udUSXAnxnwwJi4umCFnMQs

4

Hey @Mawiwawi - In order to write a list (multiple values) to a Google Sheet, you’ll need to switch the Writer Mode from Add a single new row to Add new rows. Let me know if this works for you.

image
image3024×1714 270 KB