I am trying to use Formatter to eliminate the +1 from phone numbers before they get sent to a Google sheet. The first thing it asks me is the Event. The Event list is empty and it won’t let me do anything else.
Would love some insight on this. Thanks. -Gabe
Best answer by oneillgBest answer by oneillg
Ah, I think I got it. I was trying to use this as a separate Zap. I think the idea is to insert the formatter into a current zap. i.e. Facebook Leads - > Formatter → Google Sheets. Thanks again @Troy Tessalone for helping.
I think I answered my own question. I needed a Trigger like Google Sheets to happen before the Formatter. I am trying to remove the +1 in phone number with an empty string. So I use Text, then +1 and left the next field blank. I connected it with the column in question. But it says it cannot Publish because I am missing a step. Anyone know of an example online to do this? Thanks.
Hey thanks Troy. But when I do that I get the same result. “Publish” is greyed out and the message is “Please add another step. This type of step needs to be followed by another.”
@Troy Tessalone That’s helpful, thanks! Let me play with it then and if I still can’t get it to go then I’ll post screen shots. Thanks so much for your help.
Ok so I create a Google Sheets trigger drilling down to the phone number column being updated, followed by Formatter to remove the “+1”. It says it needs another step. If I go back to that Google sheet it tells me a loop is going to happen. Just confused as to what final step it’s looking for.
Ah, I think I got it. I was trying to use this as a separate Zap. I think the idea is to insert the formatter into a current zap. i.e. Facebook Leads - > Formatter → Google Sheets. Thanks again @Troy Tessalone for helping.