Напускате Airtable? Пренесете базите си в Artavolo, проверени запис по запис. Вижте как

Turn e-mails into records with Make

Обновено

Orders, questions and invoices arrive by e-mail and then get buried in the inbox. This setup fixes that. You put the label Artavolo on an e-mail in Gmail, and within the hour it turns up in your table as a new record, ready to assign, comment on and tick off.

Three steps: an e-mail in Gmail with the label Artavolo, a Make scenario with a Gmail circle and an Artavolo circle that checks every hour, and the same e-mail as a record in Artavolo with its name, description and the status To do

The link between Gmail and Artavolo is Make (make.com), a free service that moves information between apps. You set it up once; after that it runs by itself.

What you need

  • An Artavolo account.
  • A Gmail address.
  • A free Make account. Sign up at make.com if you do not have one.

Step 1: Make a table for the e-mails

In Artavolo, create a new base, or add a new table to a base you already have. A new table always starts with three fields: Име, Описание и Статус. That is exactly what this setup fills in, so you do not need to change anything. You can rename the table, for example to Заявки.

When it is working, the table will look like this:

A table called Requests in a base called Support inbox, with five e-mails as records: the subject in Name, the sender and the message in Description, and Status To do, In progress or Done

Step 2: Get a key for Make

Make needs a key to put records into your table. In Artavolo this key is called an API токен.

  1. Click your picture or initials at the top right and choose Моят профил.
  2. Scroll down to API токени and click Manage tokens.
  3. Click Създай токен. Type Make as the title, choose your workspace, and click Запази.

The API tokens window with Add new token: the title Make, the workspace My company, and the Save button

  1. Your new key appears in a green box. Click the copy button next to it, and keep it somewhere safe for a minute: it is shown only this once.

The new token in a green box with the note that it is shown only once, a copy button next to it, and the token Make in the list below

Step 3: Add the ready-made setup to Make

  1. Отворен this link to add Artavolo to Make and click Install. You only do this once.
  2. Download the ready-made setup: make-gmail-to-artavolo.json. Your browser saves it in your Downloads folder.
  3. In Make, click Scenarios on the left, then Create a new scenario.
  4. At the bottom of the screen, click the ... button, choose Import Blueprint, pick the file you downloaded, and click Запази.

You now see two circles joined by a line: a red one for Gmail and a blue one for Artavolo.

Step 4: Connect your Gmail and your Artavolo

  1. Click the red Gmail circle. Next to Connection, click Добави, sign in with your Google account and allow access. Click Запази.
  2. Click the blue Artavolo circle. Next to Connection, click Добави. Paste the key from step 2 into API токен, leave the address as it is, and click Запази.
  3. Under База, choose your base. Under Таблица, choose your table. Name, Description and Status appear below, already filled in with the e-mail's subject, sender and message.
  4. Click Запази at the bottom of the window, then the save icon at the bottom of the screen.

Step 5: Try it

  1. In Gmail, open any e-mail. Click the label button at the top (it looks like a tag), choose Create new, type Artavolo and click Create.
  2. Back in Make, click Run once at the bottom left.
  3. Open your table in Artavolo. The e-mail is there as a new record.

Nothing came in? The first time, Make only looks at e-mails that arrive after the setup was made. Right-click the red Gmail circle, choose Choose where to start, pick All, and click Run once again.

Step 6: Let it run by itself

At the bottom left of the scenario, turn the switch on. From now on Make looks for new labelled e-mails on its own, every hour.

A note on Make's free plan: it allows 1,000 actions a month, and every check counts as one, even when there is nothing new. Checking once an hour uses about 720 a month, which fits. To change how often it checks, click the small clock on the red Gmail circle.

Ideas to make it yours

  • Catch e-mails without a label. In the Gmail circle, the Заявка box says label:artavolo. Replace it with from:orders@yourshop.com to catch every e-mail from that sender, or subject:invoice for every e-mail with "invoice" in the subject.
  • Another starting status. In the Artavolo circle, Status says To do. Type another of your statuses, or leave it empty.
  • Outlook instead of Gmail. Delete the red circle, add Make's Microsoft 365 Email app in its place, and drag its subject, sender and text into the Artavolo circle.

Добре е да знаете

  • Records are added in your name, and they show in the record's history like any change.
  • Very long e-mails are cut after 5,000 characters. Attachments stay in Gmail.
  • Taking the label off an e-mail does not remove its record.
  • To stop it, turn the switch off in Make, or delete the key in Artavolo under Manage tokens.

Свързани