I need an incoming phone number as variable to compare against a google sheet but when in custom tools I write the value as {{caller.PhoneNumber}} it takes it as a string

In Vapi, {{caller.PhoneNumber}} is a string, so extract it as a string variable (like incomingNumber), optionally normalize it, and use that for comparison with your Google Sheet..