Contact Sales
Login

Author: Casper

Categories
article

Setting Up Timed Emails with AITable.ai and make.com

Emails have become the bane of existence for many professionals. The monotony of drafting and sending out similar content day in and day out can be a soul-sucking endeavor. In some industries and roles, sending out regular emails is a non-negotiable part of daily tasks.

For example, marketing teams have to send out newsletters to subscribers, sales teams need to send out prospecting emails, and HR departments must dispatch updates and announcements. This repetitive, time-consuming task is begging for automation.

With AITable.ai and make.com, you can effortlessly set up automated timed emails, freeing up your time for more strategic initiatives.

Step by Step Guide: Setting Up Timed Emails

With AITable.ai and make.com, you can easily set up automated, timed, and cyclical email dispatches using just two modules.

Firstly, create a new Scenarios in make.com, choose AITable for module search and Search Records for action. click the clock in the icon to set the timing, you can set the time of the trigger as well as the loop.

Timed Emails

Then, set up AITable in detail. Associate your own AITable account, select the corresponding space and the datasheet containing CRM-related data information, including the customer’s information, follow-up status, email address, etc..

Timed Emails

Focus on filtering who to send emails to regularly. With Filter settings, you can add rules. The example sets up to send emails to the customer’s email address when the customer’s tage field is Initiatie Contact.

Timed Emails

Save to confirm success and go to the next step.

Add the second module, select email, and then configure the email SMTP connection and related mailbox and email information, you can refer to the variable information in AITable.ai to form the template in the email body.

In addition, you can add recipients in the Cc or Bcc fields. There are a lot more options than in AITable.ai for sending emails.

Timed Emails

Thus, the automated process of sending emails at regular intervals is complete.

Unleashing the Power of Automated Workflows

The magic of AITable.ai and make.com’s integration goes beyond just setting up automated emails. It opens up a world of possibilities for automating your work processes and boosting your productivity.

With these tools, you can set up automated processes to run at specific times, activating when certain conditions are met. This feature is perfect for automating tasks that require repeated actions at regular intervals, effectively preventing manual oversights.

For instance, you can set a task to remind team members via email or messaging platforms to fill out their morning reports at a specific time each weekday morning. You can schedule a weekly task, such as at 9 AM every Monday, to send reminders about the upcoming meeting.

Take The Leap: Embrace Automation Today

In this digital era, automating your office workflows with AITable.ai and make.com can elevate your operations to new heights. It’s more than just setting up timed emails; it’s about harnessing the power of automation to transform your work processes.

No matter the complexity of your tasks, with AITable.ai and make.com, you can create an automated solution tailored to your needs. Embrace the future of work today, and let automation take your productivity to the next level.

Read more about AITable.ai
Categories
article

AITable.ai Automation Trigger: Achieve update record with Record Matches Conditions

In our daily workflows, automation triggers play a crucial role. They automate tasks to run whenever specific conditions are met, saving our time and effort. However, we may encounter some limitations when using these triggers. For instance, AITable.ai currently does not offer an “Update Record” automation trigger.

So, how can we achieve a similar effect without this particular trigger? The answer lies in leveraging the “Record Matches Conditions” trigger. This article will guide you through how “Record Matches Conditions” can mimic the “Update Record” effect.

Understanding Airtable’s Automation Trigger: When Record Matches Conditions

Before we start, let’s first understand what the “When Record Matches Conditions” trigger is. This is a trigger that initiates an automation to run anytime a record in a specified table matches one or more configured conditions. For example, an automation task, such as sending an email to team members, could be triggered when a record’s status changes to “Complete”.

When using this trigger, there are some considerations to keep in mind. First, the trigger will run when a record matches the conditions you define in a particular automation’s configuration. Second, records that currently match the set conditions will not cause the trigger to fire. In other words, records must change states to match the conditions for the trigger to start the automation.

How “Record Matches Conditions” Can Mimic “Update Record”

Even though AITable.ai currently does not offer an “Update Record” automation trigger, we can achieve a similar effect using “Record Matches Conditions”. Specifically, you can set it to activate when a {specific field} ‘is not empty’, as shown in the picture below. Then, each time you update the {specific field}, as long as the field is not empty, the automation will be triggered.

For instance, suppose you have a table for tracking project statuses. You want an automation task, like notifying the project manager, to be triggered each time a project status changes. In this case, you can set a condition that triggers the automation when the project status field is not empty. This way, each time the project status changes, as long as the status field is not empty, the automation will be triggered.

Setting Up an Automation to Trigger When a Record Matches Conditions

Now, let’s take a look at how to set up an automation to trigger when a record matches conditions.

Step 1: Create Automation Node

Click the “add” icon at the top left corner to view the list can be created:

Achieveupdate record with Record Matches Conditions

To create an automation node, click on “New automation” in the list. An Automation node will then be created and jump to the Automation Configuration panel.

Step 2: Configure the triggers and actions

Trigger Select Record Matches Conditions.

Select a datasheet in current space. Then,select match conditions: Add one or more matching conditions.

Achieveupdate record with Record Matches Conditions

Next, you can add actions that are required for the automation.

Achieveupdate record with Record Matches Conditions

Step 3: Enable the automation

Once you have configured and saved the triggers and actions, the final step is to enable the automation.

Achieveupdate record with Record Matches Conditions

Conclusion

Even though AITable.ai does not offer an “Update Record” automation trigger, we can achieve a similar effect with “Record Matches Conditions”. This provides us with greater flexibility and freedom, allowing us to customize automation tasks according to our needs. We look forward to AITable.ai offering more automation triggers in the future to meet our diverse needs.

Read more about AITable.ai
Categories
article

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

Forms are extensively used in high-frequency work scenarios for customer information collection, lead generation, and requirement gathering. The challenge lies not only in collecting these leads or requirements but efficiently allocating and notifying the responsible individuals. This has become an urgent issue to address.

However, with AITable.ai and its latest supported connector, Pabbly, this issue can be effortlessly resolved by constructing an automated workflow.

Understanding the Power of AITable.ai and Pabbly

Before we delve into the specifics of how to set up this automated workflow, it is essential to understand the roles and capabilities of AITable.ai and Pabbly in the arena of automation.

AITable.ai, as we have previously explored, is a robust work platform that simplifies workflow automation with a visual database. It connects to a plethora of apps and services, making it a potent tool for data management and automation.

On the flip side, Pabbly is a new addition to AITable.ai‘s arsenal of connections. Pabbly is an all-in-one business management software that combines several essential tools under one roof. It includes billing and subscription management, email marketing, and automation features. Its integration with AITable.ai paves the way for new possibilities in workflow automation.

Filtering Record to Send an Email After Form Submission

Imagine this scenario: you’re collecting user feedback and requirements for a software service, which comes in both WEB and APP versions, each with a different person in charge. How would you ensure these individuals receive timely notifications and can follow up accordingly?

The solution lies in setting up a workflow as follows: once a customer submits a feedback form, the system promptly determines the software version, then filters records that include the specified version from the form submission, and finally auto-sends an email containing the record details to the responsible person.

This automation can be easily achieved using AITable.ai and Pabbly: Filtering Record to Send an Email After Form Submission.

Step 1: Form Submission

First, build a customer feedback datasheet on AITable.ai and generate a corresponding form. AITable.ai supports one-click bidirectional conversion between tables and forms, automatically collecting data from the form to the table.

Next, create a new workflow in Pabbly. In the ‘Choose Your First Application: Trigger’ section, search and select AITable.ai, and choose ‘New Form’ as the Trigger Event.

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

Connect your AITable.ai account (you’ll need to enter your API Token the first time you set this up), and choose the space, table, and specific view you want to link.

Save and test the setup. After clicking the test button, submit a form on AITable.ai for testing, and if successful, proceed to the next step.

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

Step 2: Filtering Record

Add a Filter by Pabbly and select ‘Filter Values’ as the action event.

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

Then, set up a condition. Choose the value of the field in the form where the version is located, and set it to equal to ‘WEB’. (Here, we choose to filter the form submission records whose version is WEB).

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

Test the setup again, and if everything works, move on to the next step.

Step 3: Send an Email

Search and select Gmail, and choose ‘send email’ as the Action Event. Then, connect your Gmail account.

Configure detailed email settings, including the recipient’s email, Cc, Bcc, sender name, email subject, reply to, and even attachments.

You can also design an email content template using data from AITable.ai that was read in the first step.

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

Once the test is successful, your workflow is complete. Other filter conditions can be set up in the same way.

AITable.ai x Pabbly: Filtering Record to Send an Email After Form Submission

This workflow is not only applicable to user feedback collection but fits most form collection and task assignment scenarios, such as sales lead collection and distribution notifications.

Conclusion: Harnessing the Future of Data Management Today

The collaboration between AITable.ai and Pabbly is more than just an integration; it marks a paradigm shift in the landscape of data management and automation. This powerful combination offers more than automated email notifications; it opens up a world of possibilities in connecting a range of software services and building elaborate automated workflows, thereby significantly enhancing team efficiency and productivity.

The call to embrace the future of data management is more pressing than ever. Armed with AITable.ai and Pabbly, you are equipped to unlock the full potential of your data, transforming the way you manage and process information. The future of data management is not just on the horizon – it’s within your grasp today.

Read more about AITable.ai
Categories
article

How to Use AITable.ai and make.com’s ‘Search records’ for Bulk Data Searching and Processing

In today’s fast-paced digital world, automation has become an integral component of most operations. Amongst these, a one-to-one relationship often serves the foundation for many processes. However, when the requirement expands to handling multiple records, we often find ourselves in a void, scrambling for a simple and efficient solution.

Enter AITable.ai and make.com’s ‘Search records’ action – a game-changer in the realm of bulk data searching and processing.

Demystifying AITable.ai and make.com

Before diving into the transformative ‘Search records’ feature, let’s familiarize ourselves with the players in the game – AITable.ai and make.com.

AITable.ai is a robust work platform that leverages the power to organize any data effortlessly. AITable.ai simplifies workflow automation with a visual database; connects to 6,000+ apps via Zapier, Make, Pabbly, and Activepieces.

On the other hand, make.com is a third-party service that connects AITable.ai to a plethora of other apps and services. It enables automation by creating a network of interconnected apps that act according to pre-defined triggers and actions.

Unveiling the Power of ‘Search records’

The ‘Search records’ action, in other connectors it may be called “Find Records”, is a powerful tool offered by AITable.ai and make.com. It is designed to search a specified table in AITable.ai to find if the incoming data from the trigger app matches any existing records. This feature is particularly useful when you need to handle multiple records at once, enhancing the efficiency of your automation processes.

Example: Streamlining Communication with ‘Search records‘

To illustrate the power of ‘Search records’, let’s consider an example: Imagine you’re a member of a marketing sales team, dealing with customer information daily. This entails clicking into the spreadsheet to find the corresponding customer information, which can be quite tedious.

Now, you can use the ‘Search records’ action in conjunction with automated workflows to solve this issue.

First, create a new Scenario on make.com, search for AITable.ai, and select ‘Search records’.

Connect your AITable.ai account (you’ll need to enter your API Token the first time you set this up), and choose the space, table, and specific view you want to link.

Next, configure the search criteria. You can choose to search by ‘Filter By Formula’ or ‘Field’. For ‘Filter By Formula’, you can write a formula for the search conditions. Here, we’re setting it to when the value of the status field is ‘ready’ (i.e., when the customer’s status is ready, the next action can proceed):

Use 'Search records' for Bulk Data Searching and Processing

The ‘Field’ search allows you to search records by selecting a field and logical condition:

Use 'Search records' for Bulk Data Searching and Processing

While we’re at it, let’s also set the frequency for the Scenario to trigger.

Use 'Search records' for Bulk Data Searching and Processing

Next, we add Slack, connect our own Slack account, and fill in the configuration information, mainly the channel you want to send messages to, and the text. Here, we compose a message and refer to the record information found in the previous step, selecting the email information variable:

Use 'Search records' for Bulk Data Searching and Processing

Test run it, and now your Slack channel can receive daily notifications of the customer email information that needs to be handled that day.

Conclusion: Embrace the Future of Data Management

The ‘Search records’ action is more than just a tool. It’s an innovation that is transforming the landscape of data management and automation. By integrating AITable.ai and make.com, you can unleash the full potential of your data, enhancing efficiency and productivity.

As we continue to explore the exciting world of automation, it’s crucial to leverage the right tools. AITable.ai and make.com’s ‘Search records’ feature is one such tool that promises to revolutionize the way we manage and process data. So why wait? Embrace the future of data management today.

Read more about AITable.ai
Categories
article

Enhancing Team Collaboration Safety with AITable.ai’s Powerful Permission Management

In the era of digital transformation, data is the lifeblood of any organization. It fuels decision-making, innovation, and productivity. However, the process of sharing and managing this data across teams poses significant challenges, especially concerning data security. Striking a balance between collaboration and data security is a puzzle that organizations worldwide grapple with daily.

This article shines the spotlight on how AITable.ai‘s robust permission management system enhances team collaboration safety.

Understanding Permissions in AITable.ai

Permissions are the cornerstone of data security in any collaborative platform. They define who can view, edit or manage the data, ensuring that sensitive information is only accessible to authorized personnel. In AITable.ai, permissions are stratified into three broad categories: permissions for space management, permissions for files, and permissions for field management.

  1. Permissions for Space Management: This type of permission allows users to alter, add, or delete sub-admins within the workspace. It provides the capability to control who has access to manage the overall workspace.
  2. Permissions for Files: These permissions govern the accessibility and editability of files within the workbench. They determine which members are allowed to view or edit specific files, ensuring data integrity and confidentiality.
  3. Permissions for Field Management: These permissions control which fields can be viewed or edited by which collaborators. It allows for granular control over data access, ensuring that sensitive fields are only accessible to authorized individuals.

Batch Permission Management for Teams, Members, and Roles

AITable.ai’s permission management system goes beyond individual permissions. It allows for batch permission management within the space settings organization, enabling users to set and manage permissions in bulk for efficiency.

Firstly, users can create different teams and assign varied permissions to members within these teams.

Furthermore, users can freely create role groups, adding any department or member to one or several role groups for flexible permission control.

What’s more, the master administrator and sub-administrators of the space can be changed and added or subtracted according to the unique needs of the organisation.

Permission Management

Permission Isolation for Data Security

AITable.ai goes the extra mile in data security by offering comprehensive permission isolation. Whether it’s a datasheet, a column, or a folder, users can effectively isolate data by editing or removing permissions. And this ensures that unauthorized individuals cannot access sensitive data.

Permission Management

Furthermore, users can set up teams to be invisible to each other, enhancing data security by preventing unauthorized access or viewing.

Permission Management

Team and Private Areas

AITable.ai’s innovative design includes the concept of Team and Private areas.

The Team Area is designed to enhance internal communication, resource sharing, and collaborative decision-making. And it supports real-time collaboration among multiple members, making the workflow smoother and more efficient. By default, all files and information in the Team Area are accessible to all team members, ensuring transparency and seamless collaboration.

Permission Management

The Private Area provides each member with a secure, personal workspace. Here, members can work independently on tasks or datasheets that are not ready to be shared with others. In short, this design respects individual work habits and privacy needs, allowing members to freely record thoughts, draft plans, or process personal files until they are ready for collaboration.

Permission Management

Conclusion

AITable.ai’s robust permission management system is a powerful tool in enhancing data security in team collaboration. It allows for granular control over data access, ensures data confidentiality, and fosters efficient collaboration. By leveraging AITable.ai’s permission management system, organizations can strike a balance between data security and collaboration, driving productivity and innovation.

We encourage you to explore and integrate AITable.ai‘s permission management functionalities in your team, unlocking new possibilities for growth and efficiency.

Read more about AITable.ai

Please leave your contact information first.