Automate your data workflows with AITable.ai and OpenAI

AITable.ai and OpenAI: Automate your data workflows
AITable
·
2/26/2024
·
5 min. read

In this tutorial, we will show you how to connect AITable.ai and OpenAI through Albato to generate a summary based on data from AITabale.

AITable.ai and OpenAI integration can benefit data analysts, researchers, developers, and professionals dealing with extensive datasets across various domains and industries. This scenario is designed to meet the needs of individuals and teams seeking a robust solution for data-driven insights and information extraction.

How to create automation

Sign in to your Albato account. Go to the Automation section and click the Create new automation button.

Example (1).png

The first step is to set up a trigger.

Alttext.png

Triggers are events that trigger an automation. All triggers run in real time, that is, data is transferred the moment the event occurs.

  • Choose AITable.
  • Choose the New record event.
  • Specify your AITable connection.
  • In the Additional parameters fields, select the spaces, folders and tables that you want to use.

You can connect your AITable.ai account to Albato by following these instructions if you haven't already done so.

AIT+OpAI.png

Click the Add a trigger button and move on to the next step - set up an action.

AIT+OpAI (1).png

Actions are what Albato performs when your automation is running. Actions also allow you to transfer data to other apps and systems.

  • Choose OpenAI.
  • Choose the Create chat completion action.
  • Specify your OpenAI connection.

You can connect your OpenAI account to Albato by following these instructions if you haven't already done so.

AIT+OpAI (2).png

Click the Add an action button and Map the fields.

Set up the model, temperature, and other parameters - this is where you can get creative. Don't forget to assign the role (assistant) and craft the message text, which serves as the prompt.

AIT+OAI.png

The final step is to send the response from OpenAI to the AITable space. To do this, click on + and then select Action.

  • Choose AITable.
  • Choose the Update the record event.
  • Specify your AITable connection.
  • In the Additional parameters fields, select the AITable space, folder and table where you want to receive the created summary.

AIT+OpAI (3).png

In the mapping, choose the variable from AITable in the Record ID field. In the Summary field choose the result of the OpenAI action - Response content.

Click the Save button to finalize the setup.

AIT+OpAI (4).png

It's time to activate the integration! Start the scenario and see the seamless automation in action.

AIT+OpAI (5).png

The integration of AITable.ai and OpenAI via Albato provides users with a wide range of possibilities to enhance their data analysis capabilities.

If you have questions about setting up integrations, contact our technical support through the the live chat on our website.


AITable
OpenAI