Google Sheets Read & Write

This template allows you to lookup a specific keyword in a specific column and then read and or write from/to a target column of the row where your keyword was found. Essentially giving you the ability to create automations that can be launched based on the data found in the initial lookup, allowing you to enrich/modify existing data/rows within the same Google Sheet document or to create/update data on a second Google Sheets based on the data available in the first Google Sheets.