Skip to content

How Vocal uses Zapier to do three times the work

By Ellie Huizenga · January 3, 2022
Vocal-customer-story-header-image

The typical writer archetype is one struggling to make ends meet in a small, dark apartment—and for a good reason. It's not easy to make money as a creative, and it's not often that you find a company designed to help creatives get discovered and rewarded for good content. But that's the exact niche Vocal fulfills. 

A publishing platform that connects creators with storytelling tools and engaged communities, Vocal is an online home base for all types of creatives—writers, musicians, filmmakers, and artists. Since 2016, they've scaled to over 1.2 million creators and roughly 11 million monthly readers. 

But with that growth came scaling challenges. Robby Tal, Head of Business Intelligence who oversees Vocal's data environment, paid media, and email marketing efforts, realized they needed to automate some of their processes to continue to grow.

With developer resources focused on other projects, Robby went searching for platforms that would allow him to automate workflows between different applications in a scalable, reliable way—and that's when he found Zapier. 

Our stories explore how people at businesses of all sizes use Zapier to solve common problems, get more done, and move forward faster. If you haven't yet, try Zapier for free to see what we're all about.

Challenge #1: Triaging stories submitted by content creators

In the past, when content creators submitted their work, Vocal would manually update the story status in PostgreSQL and send it over to the moderation team for review in SendGrid before approving it for publication. It was a tedious process, requiring lots of manual updating. 

As Vocal grew, their story submission queue grew, too. It was a good problem to have. They had amazing content by talented creators ready to be shared on their site, but they were struggling to respond to all the submissions in a timely manner.

The solution: Automating the tedious tasks

To reduce the time between story submission and publication, Vocal uses Zapier to automate the repetitive and tedious tasks. 

Now every time a story is submitted to Vocal, a record is automatically created in their PostgreSQL stories table. Instead of manually updating the status of new story submissions, Vocal uses a Zap to automatically set the status to "needs review".

This same Zap also notifies the next person in the round-robin queue on the Vocal moderation team via SendGrid—so someone can immediately take action.

Zapier has allowed our Business Intelligence team of 3 to execute as if we had 3x the staff.

Here are some ways you can send notifications from PostgreSQL:

Send SendGrid emails for new PostgreSQL custom query row matches

  • PostgreSQL logo
  • SendGrid logo
PostgreSQL + SendGrid
More details
    Need a way to quickly react to specific new database information with your transactional email? Then this PostgreSQL-SendGrid integration is for you! Once it's been set up, Zapier will watch your PostgreSQL database and perform your chosen custom query automatically and regularly, sending out a new email via SendGrid whenever a new row match is found. Save time by not running the query and improve your visibility with formatted emails, all in one fell swoop.

    Get Slack messages for new custom query matches on PostgreSQL

    • PostgreSQL logo
    • Slack logo
    PostgreSQL + Slack
    More details
      Searching your database with the same query over and over can get quickly get tiresome, and even more so if you have to provide updates to the team about it. If you set up this Zap, however, both those issues will be taken care of for you automatically. After it's active, any new row found to match your custom query on PostgreSQL will automatically result in a message being sent to the Slack channel of your choice, containing all the information you need to stay on top of new items without missing a beat.

      Post Slack messages for new rows added to PostgreSQL

      • PostgreSQL logo
      • Slack logo
      PostgreSQL + Slack
      More details
        Need the team to get an update the moment new entries are added to your PostgreSQL database? Don't bother sending them messages yourself—let this Zap do that instead! Once you set it up, a new message will be sent on Slack automatically for every new row added on PostgreSQL. Enter all the fields you need during configuration, then sit back and relax as Zapier automation makes sure everyone is in the loop at all times.

        Send emails on Gmail for new custom query matches on PostgreSQL

        • PostgreSQL logo
        • Gmail logo
        PostgreSQL + Gmail
        More details
          Need to make sure your contacts are notified the moment a new row on your PostgreSQL database matches some particular conditions? Activate this Zap and we'll take care of that for you. Once you do, any new match for a PostgreSQL custom query will automatically send off a new email via Gmail, informing all your recipient(s) of what's new without forcing you to interrupt the rest of your activity.

          Challenge #2: Sending targeted nurture campaigns to creators

          The submission process wasn't the only challenge the Vocal Business Intelligence team wanted to solve. They also needed to easily enrich their creator data so they could send the right nurture content at the right time. 

          Vocal wanted to use data they had in PostgreSQL and Stripe to send out targeted email campaigns to their creators. They didn't have the time to aggregate the data and assign email campaigns manually, but they knew it would provide a better experience for their creators. 

          The solution: Automating the whole process

          Instead of jumbling together a bunch of different workflows, Vocal took the time to set up an intentional, streamlined process for updating their lead data for targeted marketing campaigns. 

          They created a Zap that uses custom SQL to query PostgreSQL and Stripe. Based on the data, they send out over 20+ variations of behavioral and action-based emails via SendGrid and Iterable. With this workflow, they've been able to scale their business—automating more than 1 million tasks with Zapier each month. 

          Are you new to lead management? Explore our infographic: the beginner's guide to lead management or read through our post about how automation can help you nurture and manage leads

          The result: The Vocal Business Intelligence team did three times the work

          By streamlining their work processes with automation, Vocal can get more done—in less time.

          Without Zapier, I'm estimating that we would need at least 10 additional staff members (on top of our 35 in-house employees) to get everything done.

          When faced with obstacles, Robby says he asks his team to look to Zapier to see if it can help be part (if not all) of the solution. 

          Read more about some of Vocal's favorite Zapier tips and tricks in their post about optimizing their Zaps

          Related reading:

          What's your story? Tell us how you use Zapier to do more. You can also read even more customer stories and find new ways to improve your workflow and productivity.

          Get productivity tips delivered straight to your inbox

          We’ll email you 1-3 times per week—and never share your information.

          Related articles

          Improve your productivity automatically. Use Zapier to get your apps working together.

          A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'