Gmail and Webflow integration

Who it's for This n8n workflow is designed for business owners, sales teams, and customer support managers who want to automate their lead capture and immediate acknowledgment process. The workflow creates an end-to-end multi-channel communication system that captures form submissions directly from Webflow, cleans and structures the data, saves it securely to a Google Sheet, and instantly sends personalized "Thank You" messages via both Email and WhatsApp. Features Captures Webflow form submissions in real time Cleans and structures data into JSON using custom JavaScript Automatically saves leads to Google Sheets (Name, Email, Phone, Message, Date) Sends instant email confirmation to users Verifies WhatsApp numbers via Rapiwa API Sends WhatsApp messages only to valid numbers Handles multiple submissions with delay to avoid API limits Uses conditional routing for error-free automation flow Requirements Webflow OAuth2 API**: To authenticate the trigger node and receive real-time form submission webhooks from your specific site. Google Sheets OAuth2 API**: For appending new lead data to your designated spreadsheet ("Sales - Save to Google Sheets"). Gmail OAuth2 API**: To send the automated confirmation emails to your leads from your connected Gmail account. Rapiwa API Credentials**: For verifying the validity of WhatsApp numbers and sending out the WhatsApp text messages. Configure Credentials Webflow API**: Ensure you select the correct Site ID in the trigger node settings to listen to the right website's forms. Google Sheets**: Configure with edit access to the target spreadsheet and ensure the sheet name ("Webflow") exactly matches your tab. Gmail API**: Connect the Google account you wish to use as the sender for the confirmation emails. Rapiwa API**: Add your Rapiwa API key to enable WhatsApp number verification and messaging capabilities. Customize Messages**: Update the default text in the "Send a message" (Email) and "Rapiwa" (WhatsApp) nodes, making sure to replace add_your_brand_name with your actual brand name. Important Notes Ensure consistent field names between Code node and Google Sheets (e.g., email, name must match exactly with sheet headers like Email, Name) to avoid empty values WhatsApp logic: $json.exists === false means the number is valid and exists on WhatsApp, so the True branch sends the message—don’t invert this Loop Over Items has two outputs: top output goes back into the 5s wait loop, bottom output continues main processing flow WhatsApp message uses cleaned sheet data ($('Store Data in Sheet').item.json.Name) to ensure accurate formatting Replace add_your_brand_name in all templates to avoid unprofessional messaging Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: spagreen.net Developer Portfolio**: Codecanyon SpaGreen

Who it's for This workflow is for sales and marketing teams using Webflow as their primary lead capture tool and Pipedrive as their CRM. It automates the entire lead intake process, from form submission to CRM entry and team notification, eliminating manual data entry. How it works A Webflow form submission triggers the workflow and captures lead fields (name, company, email, phone, website URL, message). Key fields are mapped and phone numbers are cleaned and formatted with the correct international dial code using a custom code node. The workflow searches Pipedrive for an existing organization matching the company name. If none is found, a new one is created. Results are aggregated. It then searches for the contact person by name. If found, their record is updated; if not, a new person is created and linked to the organization. A new lead is created in Pipedrive associating the person and organization. In parallel: a Discord message notifies the team, a Gmail confirmation email is sent to the lead, and — if a website URL was provided — the organization's URL field in Pipedrive is updated. How to set up [ ] Connect your Webflow OAuth2 credentials and configure the Form Trigger with the correct site [ ] Add Pipedrive API credentials to all Pipedrive nodes [ ] Add Discord Bot credentials and set the target server and channel in the Notify Team on Discord node [ ] Add Gmail OAuth2 credentials and adjust the email subject and body in Send Confirmation Email [ ] Review the Format Phone Numbers code node to confirm the country detection logic matches your audience [ ] Adjust the Filter Valid Organization URL conditions if needed Requirements Webflow account with a published form Pipedrive CRM account Discord server with a bot token Gmail account with OAuth2 access How to customize Extend the Set Contact Fields node to map additional Webflow form fields into Pipedrive custom properties. Replace the Gmail node with a SendGrid or SMTP node to use a transactional email service instead. Add a Slack node alongside or instead of Discord for team notifications if your team uses Slack.