Bulk add Liny tags to friends who match the criteria using a Google Sheets list
Bulk add Liny tags to friends who match the criteria using a Google Sheets list
Launch this workflow to connect
Liny &
Google Sheets
!
■Overview
Do you manually add tags while checking customer data in Google Sheets to manage segments in Liny? Identifying friends who meet conditions such as the number of purchases and adding tags one by one is time-consuming and prone to errors.
With this workflow, you can automate the process of extracting users who meet specific conditions from a Google Sheets list and bulk-adding tags to their friends in Liny.
With this workflow, you can automate the process of extracting users who meet specific conditions from a Google Sheets list and bulk-adding tags to their friends in Liny.
■Who This Template Is For
- Anyone who manages customer data such as purchase history in Google Sheets and finds it time-consuming to connect it with Liny
- Marketing professionals who want to efficiently tag contacts for segmented messaging based on conditions such as the number of purchases
- Anyone who wants to automate data-matching and tagging tasks to prevent errors in filtering conditions and missed tags
■Benefits of This Template
- Complete condition-based tagging with a single manual trigger, reducing the time spent matching lists and performing manual tasks.
- Process data in sync with Google Sheets to reduce the risk of human error, such as missing eligible contacts or assigning the wrong tags.
■How the Flowbot Works
- First, connect Google Sheets and Liny to Yoom.
- Next, set the trigger to “Manually start the Flowbot.”
- Next, configure the Google Sheets operation to “Retrieve multiple records” and retrieve the list of contacts to tag.
- Next, configure the repeat process (loop) feature to process each item in the retrieved list.
- Finally, configure the Liny operation within the loop to “Bulk add tags to friends.”
※ “Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization Options
- In the Google Sheets settings, specify the spreadsheet ID and sheet name containing the list of friends to tag, along with the conditions for retrieving records.
- In the loop settings, specify the values you want to process repeatedly, such as friend IDs, from the information retrieved from Google Sheets in the previous step.
- In the Liny settings, specify the IDs of the tags you want to add.
■Notes
- Connect both Google Sheets and Liny to Yoom.
- Actions between “Repeat the same process” operations are available only on the Team and Success plans. On the Free and Mini plans, operations and Data Connect configured in the Flowbot will result in errors. Please keep this in mind.
- Paid plans such as the Team and Success plans include a two-week free trial. During the free trial, you can use apps and features (operations) that are subject to plan restrictions.
Check Out Similar Templates!
Add a friend tag in Liny when a Stripe payment fails
Detect failed Stripe payments, tag customers in Liny, look up customer details in Google Sheets, and send notifications via LINE. Reduce manual checks and data entry errors while enabling faster follow-up with customers who have outstanding payments.
When a Shopify order is paid, add a tag to a friend in Liny and send a message on LINE
Automate Liny tag updates, AI-powered message creation, and LINE Official Account broadcasts based on Shopify order data. Deliver timely, personalized outreach to every customer—ideal for e-commerce operators and marketers looking to improve customer satisfaction and drive repeat purchases.
See more
About the Apps
Liny
Related apps
Templates using
Liny
Detect failed Stripe payments, tag customers in Liny, look up customer details in Google Sheets, and send notifications via LINE. Reduce manual checks and data entry errors while enabling faster follow-up with customers who have outstanding payments.
Automatically tag customers in Liny and notify your LINE Official Account when a Square payment is completed. Reduce missed registrations and data entry errors so you can focus on customer support.
Use completed Stripe payments to retrieve customers and automatically tag them as Liny friends. Reduce manual tagging effort and missed tags while streamlining customer segment management.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Liny
With Yoom, you can connect with Liny to easily automate your administrative tasks, such as creating friend profiles, adding or removing tags, and setting status marks. For example, you can automatically update Liny contact information using application details received from Google Forms, or gather chat histories and tag lists to automatically compile them in your spreadsheets or chat tools.
see detailsTemplates
Detect failed Stripe payments, tag customers in Liny, look up customer details in Google Sheets, and send notifications via LINE. Reduce manual checks and data entry errors while enabling faster follow-up with customers who have outstanding payments.
Add a friend tag in Liny when a Stripe payment fails
Automatically tag customers in Liny and notify your LINE Official Account when a Square payment is completed. Reduce missed registrations and data entry errors so you can focus on customer support.
Add a friend tag in Liny when a payment is completed in Square
Use completed Stripe payments to retrieve customers and automatically tag them as Liny friends. Reduce manual tagging effort and missed tags while streamlining customer segment management.
Add a tag to a friend in Liny when a payment is made in Stripe
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Row Is Added
When a Row Is Updated
Flowbot operations
Execute Integration Action
Create Friend Information Field
Create Friend Info Folder
Create Tag
Update Tag
Create Tag Folder
Get Tag Folder List
Retrieve Friend List
Get Tag List
Get Response Mark List
Update Common Data
Get Common Data List
Get Common Data Folder List
Get Talk History
Bulk Remove Friends from Tag
Get Friends Linked to a Tag
Bulk Add Tag to Friends
Add Tag to Friend
Flowbot triggers
There is no action.
Flowbot operations
Execute Integration ActionCreate Friend Information FieldCreate Friend Info FolderCreate TagUpdate TagCreate Tag FolderGet Tag Folder ListRetrieve Friend ListGet Tag ListGet Response Mark ListUpdate Common DataGet Common Data ListGet Common Data Folder ListGet Talk HistoryBulk Remove Friends from TagGet Friends Linked to a TagBulk Add Tag to FriendsAdd Tag to FriendRemove Tags from FriendSet Friend Response MarkRetrieve Template ListSave MediaGet FriendRetrieve a Friend's Inflow Route ListRetrieve Inflow Route ListRetrieve List of Friends Who Passed Through an Inflow RouteRetrieve Media List
Flowbot triggers
When a Row Is AddedWhen a Row Is Updated
Flowbot operations
Set a Value in a CellGet ValuesClear ValuesCreate a New SpreadsheetCopy a Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet Sheet NamesApply a Formula to a RangeEnter Values in a RangeEmbed an Image in a CellSort by Specific ColumnHide a SheetAdd a Note to the Specified CellsInsert ColumnsDelete ColumnsWrite Values to Multiple ColumnsAdd RowsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!