- Published on
The Airtable sidebar assistant is great
- Authors
- Name
- Peter Hartree
- @peterhartree
The Airtable sidebar assistant ("Airtable Omni") is good.
I decided to play around some more, after having a great time with data enrichment.
I started with a sheet like this:
Name, Email, Job title, Organization, Job description
Some prompts I tried:
Alright, I've made a web form that I want people to fill out. And I want to make a column that contains links to that form with some of the information pre-filled in the query string. I've put an example link below. Could you make a column like this?
https://tally.so/r/XXXXXX?name=Peter+Hartree&email=p@pjh.is&job_title=AI+Uplift+Consultant
Result: a column with the following forula:
"https://tally.so/r/mKjgXD?name=" & ENCODE_URL_COMPONENT(scheduler_display_name) & "&email=" & ENCODE_URL_COMPONENT(scheduler_email) & "&job_title=" & ENCODE_URL_COMPONENT({AI Job Title (internet)})
Perfect.
Next:
Okay, please could you add an AI field to find their LinkedIn profile from the internet?
Bad. Most of the profile links were hallucinated.
I tried again:
The LinkedIn AI fields contain mostly hallucinated URLs, yet the correct profile URLs are mostly easily found if you just search for the person's name, the organization name, and the word LinkedIn. Could you try fixing this?
It worked. All the links were valid, and the correct person. Some cells were correctly marked as "Profile not found".
Why did it work the second time? Airtable had written a prompt for the AI field, and the first draft was bad.
Next:
I'd like to go through this data reading the person's name, job title, organization, and job description. Then I want to be able to mark them from 1 to 3 on a column called priority. Please make an interface for this.
Result:

Solid.
On the interface that we made earlier, I also want to see the date that their call is scheduled for. I only want to see the date; I don't care about the time. And then I would like to have a field that lets me select from, let's call the field "Next action". I want to be able to select from:
1. Send intake survey
2. Ask to reschedule
3. Cancel
It worked.
Could you add a column called "Send email" with the options:
1. Intake survey
2. Reschedule
3. Cancellation
We're going to use that to trigger an Airtable automation, which we need to create. That automation should send the person an email based on a template that I will provide.
Result:

Nice!