Automate Columns B/C/D/E in Google Sheet to a Google Search

❓Help and questions
2

Hi @ben,

  1. To create your address into a URL that searches google, please refer to the below:
    This video at 23:37 will help show you how to build the URL inside of Google Sheets using some formulas =Encode and =Concatenate.

Stop Copy-Pasting Already! How to Automate DATA ENTRY (Tutorial) - YouTube

  1. For updating your Google Sheet per applicable row, please refer to the Update Google Sheets action. Here’s a nice guide:
    How to use Update Google Sheet rows

I hope this helps, please don’t hesitate to reach out with any troubles you may have after looking at the above. It would be super helpful if you shared your GSheet publicly with full rights for further troubleshooting. Thank you!