I’ve upgraded to the “Starter” level on Zapier and oh my god, it’s a game changer. It really really beefs up your functionality. I am now able to search/replace on my spreadsheet without using a billion different services, but even more than that, I can use Zapier’s “formatter” to change all the info into the format I want. I was getting really annoyed about how the currency was formatted, so I changed it into a number and trunc’ed the .00 off it. Now it formats correctly.
Other thing I’m excited about? I automated a tweet greeting to new patrons, and I can now randomly pull from a list for each sentence. So, for example, I have a randomized greeting (Hey, Hi, Eyyy, Yo,) and then their first name; and then “I hope you enjoy” (randomized benefit of campaign), and then a randomized praise (“You’re a ROCKSTAR!”, “You’ve made my day!” etc).
Of course the first person it went live on had “The” as their first name. But uhhhh … that’s fine, lol.
Either way, I am currently using my mother’s account to do this, but I would hands down drop the dosh on this if I wasn’t. It has made things so much easier on me, and I’m looking forward to combing through my options to do more.
Will keep you updated as I find more things!