# TidyCal Booking to LeadConnector and Google Sheets Zap

> This Zap runs when a new booking is made in TidyCal, adds or updates the contact in LeadConnector, and records the booking in Google Sheets.

Section: Zapier Automations

Page: https://mburhan.com/case/zapier-tidycal-booking-to-leadconnector-google-sheets

## Project Overview

This Zap connects TidyCal, LeadConnector, and Google Sheets. When a new booking is made in TidyCal, the automation adds or updates the contact in LeadConnector and records the booking in Google Sheets.

The workflow includes filtering, text formatting, a spreadsheet lookup, and two paths to update an existing row or create a new one.

**Tools:** Zapier, TidyCal, LeadConnector, Google Sheets.

## 01. How It Works

1. **New Booking:** A new booking in TidyCal triggers the Zap.
2. **Filter and Format:** Filter by Zapier checks conditions, and Formatter processes text.
3. **Update Contact:** LeadConnector adds or updates the contact.
4. **Find Spreadsheet Row:** Google Sheets looks up the matching row.
5. **Route the Booking:** The workflow splits into two paths: one updates the existing row, and the other creates a new row.

Image: The ten-step Zap: a TidyCal booking trigger, filter and text formatting, LeadConnector, a Google Sheets lookup, and two paths that update or create a row. (https://mburhan.com/case-content/zapier-portfolio/image16.png)

## 02. Workflow Overview

Image (https://mburhan.com/uploads/711c9f3a14b00c66f8e40392.png)

## 03. Final Outcome

The Zap connects booking management, contact updates, and spreadsheet records in one workflow, with separate paths for updating an existing Google Sheets row or creating a new one.
