I’m trying to create a scenario that will watch for changes in a certain column in Google Sheets and if that cell contains a certain text string to automatically send an email to an email address in that row in Google Sheets.
It seems I need to install the Make for Google Sheets extension in Google Sheets then create a custom webhook and link to it within the particular Google sheets worksheet that I wish to monitor. I believe I have done that. I created a webhook and then pasted that value into the Make for Google Sheets extension - Settings - Webhook url. I then limit it under sheet and range so that it’s only monitoring the specific cell range I want it to watch.
Back in the scenario builder I select my Google Sheets watch changes module and select my webhook. I then do not have the option to select my workbook and worksheet. Instead I see the message “Please make sure you are using your Default Google account when setting up the Make for Google Sheets add-on.” I can click OK but it doesn’t then give me the option to select my workbook. 
The rest of the scenario looks like it should be fairly straightforward. Add a gmail scenario, add message and recipient (taken from linked spreadsheet). With a filter for cells to contain certain keywords only to trigger the email but without being able to link to my specific email I am stuck.
Any thoughts on how to resolve this appreciated.
Tom
