Google Sheets Syncro Call Logger

Name: Google Sheets Syncro Call Logger
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

12 views

0 downloads

Integrationsautomationcrmgoogle sheetsloggingsyncrowebhook

Logs phone call details from a webhook into Google Sheets and optionally adds them to Syncro.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of receiving phone call data via a webhook, checking if the call ID already exists in a Google Sheet, and if not, logging the call details into Syncro.

Key Features

Receives call data via a webhook.
Checks for existing call records in Google Sheets to prevent duplicates.
Logs call details (start time, end time, notes) to Syncro.
Formats dates and call information for Syncro.

How To Use

Import the workflow: Upload the JSON to your n8n instance.
Configure Webhook: Set up your external service to send POST requests to the provided webhook URL with call_id, date_started, date_ended, and contact details in the body.
Configure Google Sheets: Set up your Google Sheets credentials and specify the sheetId and range (e.g., 'Sheet1!A:B'). Ensure the 'Call' column is used for lookup and 'Ticket' column for storing received call IDs.
Configure Syncro (AddTimertoSyncro): Set up your HTTP request credentials for Syncro, ensuring the $env.BASE_URL is correctly set to your Syncro API endpoint and the user_id is correct.
Set Environment Variables: Configure the WEBHOOK_URL environment variable if needed.
Enable the workflow.

Apps Used

automation

crm

google sheets

logging

syncro

webhook

Workflow JSON

{
  "id": "9b45b493-dd1d-4395-b367-9f07447c65b7",
  "name": "Google Sheets Syncro Call Logger",
  "nodes": 0,
  "category": "Integrations",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.