Send commercial briefs from Google Calendar meetings to Pipedrive via Gmail

Description

Who it's for

This workflow is designed for sales teams and business development managers who use Pipedrive to track leads and Google Calendar to schedule discovery calls. It automates the sending of commercial briefs before meetings, eliminating manual follow-up steps.

How it works

A schedule trigger fires every 30 minutes and fetches upcoming appointments from a Google Calendar.
A JavaScript code node filters events matching a specific meeting title and extracts attendee emails, excluding internal team members.
Each attendee email is looked up in Pipedrive to retrieve the matching contact person.
The workflow fetches the associated lead in Pipedrive and filters out leads that don't exist or already have the "brief sent" label.
Existing notes on the lead are retrieved, and leads with at least one note are filtered out to prevent duplicate sends.
A commercial brief email is sent via Gmail to qualifying leads, and the Pipedrive lead label is updated to mark the brief as sent.

How to set up

[ ] Connect your Google Calendar account and set the correct calendar ID in the "Fetch Calendar Appointments" node
[ ] Update the JavaScript filter in "Parse Calendar Events" with your meeting title and internal team emails
[ ] Connect your Pipedrive account and verify API credentials in all Pipedrive and HTTP Request nodes
[ ] Connect your Gmail account and customize the email subject, body, and recipient field
[ ] Review the filter conditions to match your Pipedrive label IDs for the brief-sent flag

Requirements

Google Calendar account (OAuth2)
Pipedrive account with API access
Gmail account (OAuth2)

How to customize

Adjust the schedule trigger interval (e.g., once per day in the morning) to better match your meeting cadence
Replace Gmail with an SMTP or Outlook node if your team uses a different email provider
Extend the workflow to also create a Pipedrive activity or note after sending the brief, for full CRM traceability