I’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 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!