Automatically call new Google Sheets leads with Bolna and save the AI transcript back to the sheet

When a lead is added or updated in Google Sheets, this automation calls the customer via Bolna, then fetches the latest AI call transcript and writes it back into the same spreadsheet row for easy tracking and follow-up.

trigger
app icon
app icon

By Sujal Rai

Installed by 1 users

Trigger
Default app icon
Row Added Or Updated
Action
format_phone_number
Workflow step icon
Make a Phone Call
Workflow step icon
Delay
Workflow step icon
List Agent Executions
Workflow step icon
Lookup Spreadsheet Rows
Workflow step icon
Update Spreadsheet Row

Automatically call new Google Sheets leads with Bolna and save the AI transcript back to the sheet

Automatically call new Google Sheets leads with Bolna and save the AI transcript back to the sheet

Introduction

Turn every new or updated lead in Google Sheets into an instant Bolna AI phone call. After the call, the workflow captures the AI transcript and updates the correct spreadsheet row so your team always has the conversation notes in the same place.

Benefits

  • Eliminate manual calling and note-taking for new leads
  • Keep every lead’s call transcript stored directly in Google Sheets
  • Faster speed-to-lead, improving response rates and conversions
  • Reduce errors by automatically matching and updating the right row

Trigger Event

When a row is added or updated in Google Sheets (your leads sheet), the workflow starts.

Actions

  1. Format the phone number by prepending the country code (example: +91) to the “Mobile no.” value from the sheet.
  2. Place an outbound call via Bolna using your selected Bolna AI agent and the formatted phone number.
  3. Wait for a few minutes to give the call time to complete and the transcript to become available.
  4. Fetch the most recent Bolna agent execution (latest call record) and pull the call transcript.
  5. Find the matching lead row in Google Sheets by looking up the same “Mobile no.” value.
  6. Update that row’s “Transcript” column with the Bolna transcript so the lead record stays complete and searchable.

Can't find the right template?

Start with AI

Frequently Asked Questions

What does this template do and who is it for?

This template automates a specific workflow by connecting multiple apps and removing manual steps. It’s useful for anyone who wants to save time, reduce errors, and streamline repetitive tasks using automation.

Do I need technical knowledge to use this template?

No. You can install and customize this template without writing any code. Everything is done through simple configuration.

Which apps are required, and can I customize or extend the workflow?

Only the apps shown on the template page are required. You can customize messages, add or remove steps, apply conditions, connect more apps, and add extra actions like notifications, data updates, or triggering other automations.

Is this template suitable for real business use and multiple use cases?

Yes. Once configured, it can be used for live workflows and production systems. You can also duplicate the template and customize it for different teams or processes.

How long does setup take, and can I manage the workflow later?

Most templates can be set up in just a few minutes. You can pause, edit, duplicate, or delete the workflow anytime.

Do I need a paid plan, and where can I get help if needed?

You can start with the free plan; limits depend on your viaSocket plan and usage. If you need help, you can contact viaSocket support, check the Knowledge Base, or book a demo.