Google Sheet List Type Mismatch

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!

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

1 Like

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

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.

This topic was solved and automatically closed 60 minutes after the last reply. New replies are no longer allowed.