Skip to main content

Find unowned leads in Google Sheets and nudge your team in Slack

  • Nov 11, 2026 3:52 PM UTC
  • 0 replies
  • 0 views

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager

Using Zapier, read my Google Sheet called Leads and find rows with no owner or no next step. Show me the list, then wait for my OK before posting a summary in the Slack channel #sales.

 

This prompt reads a Google Sheet of leads, finds the rows with no owner or no next step, shows you the list and, once you approve, posts a summary in a Slack channel.

Apps you need: Google Sheets and Slack, both connected to Zapier MCP
Good for: sales and ops teams who track leads in a spreadsheet

Make it yours

  • Change Leads and #sales to your own sheet and channel.
  • Swap "no owner or no next step" for your own gap, like "no activity in 14 days".
  • Ask for the summary as a direct message to yourself first.

Tips

  • Because it writes to the same place every time, pin the Slack channel in Configure your actions so your AI cannot change it.

Tried it on your own leads? Tell us which gap you looked for, no owner, no next step or something else.