Having my Google sheet update and move i nfo

Hello, New here and trying out Make. Run into an issue with getting a scenario I create to work and the AI tool doesn’t seem to be able to help me. I’ll try and add my scenario as well. Here’s what I’m trying to do.

I created a Google sheets to track the guests I have on my show. I want to see if I can get Make to automate it to keep track based on scheduling in my Acuity calendar. I created a new Google sheets with 4 tabs.

Tab 1 is my sheet for potential guests that I come across and want to have on.
Tab 2 is my pre-call tab for those that book a pre-call with me on Acuity.
Tab 3 is my booking tab for those that book their actual episode on Acuity.
Tab 4 is my canceled tab for those that cancel their appointments.

I thought I had it set correctly to recognize the name field as the data I’m wanting to find and move to the appropriate sheet and remove it from where it was. I’m referencing the sheets I want it to check and thought I laid the scenario out logically how I wanted the actions to go.

Maybe I’m using the wrong types of modules I’m new to Make for sure. Thanks for any suggestions or help you can share.

Don

blueprint.json (119.0 KB)

Oh, and if you happen to look at my blueprint, I haven’t added the Canceled branch flow yet.