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
How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide
4 min. read

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide

Learn how to set up ClickUp integrations with Albato in our step-by-step guide. Unlock powerful ClickUp integrations & automate workflows to boost productivity.

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato
4 min. read

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato

Zendesk offers a comprehensive customer service solution, designed for ease of use and scalability. See how Albato can help you enhance the app’s usability!

How to use Claude Artifacts: 7 Ways with examples | Guide 2025
Claude AI
10 min. read

How to use Claude Artifacts: 7 Ways with examples | Guide 2025

Learn how to use Claude Artifacts with our detailed guide. Explore 7 best ways with real Artifact examples: web pages, prototypes, presentations and visualizations.

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato
3 min. read

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato

Gumlet is best way to stream ad-free videos on internet. It has powerful CMS to organise videos and hollywood grade DRM. See how Albato can help you enhance the app’s usability!

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy
3 min. read

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy

With Octopush, businesses are well equipped to propel their brand, promote their offers and services at scale. See how Albato can help you enhance the app’s usability!

Connect DocuSign with 800+ Apps | Simplify Document Management on Albato
3 min. read

Connect DocuSign with 800+ Apps | Simplify Document Management on Albato

DocuSign is a top electronic signature and digital transaction management platform, helping organizations manage contracts and agreements securely and efficiently. See how Albato can help you enhance the app’s usability!

Chili Piper Alternatives 2024: Top 6 Scheduling & Lead Management Tools
CalendarHero
4 min. read

Chili Piper Alternatives 2024: Top 6 Scheduling & Lead Management Tools

Discover the top 6 Chili Piper alternatives for scheduling and lead management. Compare features, pros & cons of Calendly, Dashly, Cal.com & more. Find the best fit for your business.

Customer Service Skills: Essential Guide to Handling Discount Requests
1 min. read

Customer Service Skills: Essential Guide to Handling Discount Requests

Learn essential customer service skills for handling different types of discount requests. Discover proven strategies for maintaining customer loyalty while protecting your business interests.

Passion.io Alternatives: 5 Better Options for Video Apps
2 min. read

Passion.io Alternatives: 5 Better Options for Video Apps

Looking for Passion.io alternatives? Explore 5 powerful platforms: Gurucan, Mighty Networks, Thinkific, Bettermode & FlutterFlow. Compare features, pricing & choose the best app builder for your needs.

5 Powerful Mobile App Marketing Strategies You Haven't Tried Yet | 2024 Guide
5 min. read

5 Powerful Mobile App Marketing Strategies You Haven't Tried Yet | 2024 Guide

Discover 5 powerful mobile app marketing strategies to boost downloads and user retention. Learn how to leverage automation, A/B testing, analytics, and cross-promotion tools to grow your app effectively. Perfect for developers and small teams.

How to Start an Affiliate Marketing Store
4 min. read

How to Start an Affiliate Marketing Store

Step-by-step guide to creating a profitable affiliate marketing store. Learn how to choose programs, build a site, and monetize your audience.

Top content automation tools in 2024
4 min. read

Top content automation tools in 2024

Maximize your reach in 2024 with tools designed for every content channel. Find out how top automation platforms can transform your workflow