Hello there!
First time using make and I have been in down a rabbit hole with this setup with so many system changes none of the tutorials I have watched and read (my eyeballs and head hurt) do not match what’s currently working and then sets me back to square one and I am pulling my hair out.
I figured out most of the automation pieces but the Google Sheet connection. I watched the tutorial on a workaround from using the google sheet addnon (RIP?) to doing it through the Apps Script and I believe I did the steps but the video shows a scenario with two Google Sheets, one is “perform a function” and the other one is Watch Changes, they are not connected.
My challenge is that I add the first Google Sheet connection “perform a function” I get the URL for the webhook…cool
Then when I try to add the Google Sheet connection “watch changes” (or any of the instant options) show up.
Here is the video tutorial I am following:
When I do the “watch changes” first it works but then when I add the next google sheet “perform a function” does not show up as an option.
I am assuming that something changed in how this is supposed to work and a tutorial has not been done yet…this is what Ive been experiencing several times through this project. I am not a programmer or coding so this is extremely hard for me to understand but I am pretty good at following instructions so here I am.
Please send help…or Tito’s vodka 
