’m trying to create a flow that automatically fills in company website URLs in my Google Sheets. Here’s my current setup:
Google Sheets Reader - reads company names from the sheet
Search Companies - searches for company websites (settings: Input: ‘company name’, Company Information: ‘websites’, # of Results: 1)
Get List Item - tries to get the first element from the list (index: 0)
Error Shield - added for protection
Google Sheets Writer - tries to write the found URLs to the sheet (Writer Mode: Add New Rows)
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.
I get this error:
Get List Item Failed!
Error with node input or parameter “list”. An empty value was received.
Value must be defined.
- Please double check your node inputs or parameters*
Link: https://www.gumloop.com/pipeline?workbook_id=udUSXAnxnwwJi4umCFnMQs&run_id=ExUaSdu4APMFXygB4N5smn
Thank you in advance!