Find and replace tool

Find and replace tool
Tools
·
3/16/2022
·
3 min. read

Albato has the Find and Replace tool that allows you to find values from previous steps of the automation scenario and replace, delete or modify them. This tool works like find and replace feature in Excel.

How to use

Let’s suppose we collect leads for an event from various systems in Google Sheets. One of our forms (e.g.VK) transfer a phone number in a format different from other sources. We need to replace digit 7 with 8 to correct the format. The Find and Replace tool will help us.

Step 1

Open the Automation builder section and add the tool between steps.

pub-img-8195-2.png

Select the tool and click Save button.

pub-img-8195-3.png

Step 2

Where to replace — select the list to search. In our example, we select VK Phone Number.

What to replace enter the value you want to search and replace. It can be text, digits, characters without spaces. In our example we should find and replace 7.

Replace with enter the value that should be after the replacement. If you want to delete values, leave this field empty. For our example we enter 8.

Search mode determines the replacement order if there are multiple matches at once.

  • All occurrences will replace all found matches in the given fields, e.g. 8(985)563-8886.
  • First occurrence only will replace only the first match in order, e.g. 8(985)563-87-76.
  • Last occurrence only will replace the last match in order, e.g. 7(985)563-87-86.

Our example requires the first digit replacement, thus we select the First occurrence only mode.

2022-08-16_17-24-17.png

Step 3

Now we need to set up transferring of replacement result to Google Sheets. Open the Automation builder section and click settings gear:

pub-img-8195-5.png

In the settings window, specify the field where to substitute tool’s result. Click on the field, select Albato list and the Result value from the drop-down list. In our example, Column D is for Phone numbers.

Click Save button and start the automation. Ready! We've receive new leads from VK with digit 8.


Tools

Related articles

Show more
QuickBooks CRM Integration | Boost Sales & Automate Accounting
5 min. read

QuickBooks CRM Integration | Boost Sales & Automate Accounting

In this article, you will learn how QuickBooks CRM integration can streamline your sales, invoicing, and customer data. Save time and grow your business with a seamless CRM-QuickBooks connection.

How to Automate Your Daily Tasks Using Albato And AI
3 min. read

How to Automate Your Daily Tasks Using Albato And AI

In this article, you’ll learn how to automate your daily tasks using Albato, a no-code integration platform, combined with the power of AI tools like ChatGPT, Gemini, and Claude.

Best Productivity Apps 2025 – Streamline Your Daily Tasks
13 min. read

Best Productivity Apps 2025 – Streamline Your Daily Tasks

In this article, you will learn about the top productivity apps—task managers, timers, note tools, and more—to streamline your daily workflow and boost efficiency in 2025.

How Email Marketing Automation Helps Boost Engagement
20 min. read

How Email Marketing Automation Helps Boost Engagement

In this article, you will learn how email marketing automation can increase engagement, save time, and deliver personalized content to your audience more effectively.

How Weeztix Scaled Native Integrations for 300+ Event Organizers with Albato Embedded
6 min. read

How Weeztix Scaled Native Integrations for 300+ Event Organizers with Albato Embedded

By embedding Albato, Weeztix made it way easier to integrate and automate workflows for hundreds of their event organizers.

Best Albato Use Cases for Marketing and Sales Automation
8 min. read

Best Albato Use Cases for Marketing and Sales Automation

In this article, you will learn about the best Albato use cases for marketing and sales automation. Learn how to streamline workflows, boost productivity, and drive growth.

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato
7 min. read

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato

With this setup, not only can you transfer your contact database from Quickbase to Google Contacts in bulk, but you can also keep those records updated in real time.

We’re Celebrating a Big Win!
2 min. read

We’re Celebrating a Big Win!

Explore what’s new in Albato: features, apps, and improvements

How to Automate Blog Creation from Google Sheets Using OpenAI
8 min. read

How to Automate Blog Creation from Google Sheets Using OpenAI

With this Solution, every new row in a designated Google Sheet triggers a series of actions to create SEO-friendly blog content, generate images, and notify your team—without writing a single line of code.

Best Workflow Management Software for Teams 2025
11 min. read

Best Workflow Management Software for Teams 2025

In this article, you will learn the top workflow management tools to boost team efficiency. Compare features, pricing, and find the perfect fit for your team.

Why CRM SMS Integration Matters to Your Business
5 min. read

Why CRM SMS Integration Matters to Your Business

In this article, you will learn why missed follow-ups happen so often, why CRM SMS integration solves the root of the problem, and what steps you can take to put your follow-up process on autopilot.

What Tools To Connect to OpenAI with Albato
3 min. read

What Tools To Connect to OpenAI with Albato

In this article, you will learn what tools you can connect to ChatGPT(Open AI) with Albato to set up automated workflows for different use cases.