Unfortunately, Make has incorrect instructions on its website for setting up Airtable connections.
To create a personal access token for Make’s Airtable integrations and automations, you will need to take these steps:
a) Log into Airtable with an account that has owner permissions. IMPORTANT: This should be an account that will never get deleted from Airtable. If this account ever gets deleted from Airtable, then your automations & integrations will stop working. (If you have an enterprise account, you can use a service account, which is a non-user account.)
b) Pull down from the profile icon in the upper right corner of the screen and pull down to “Developer Hub”.
c) On the next page, click on the blue button in the upper right that says "Create new token”.
d) For "Name", type “Make”.
e) Under “Scopes”, keep clicking on the “Add a scope” button until you’ve added these 3 scopes:
data.records:read
data.records:write
schema.bases:read
f) For “Access", click on "Add a base” and choose “All current and future bases in all current and future workspaces”.
g) Click on the blue button that says “Create token”.
h) IMPORTANT: Your personal access token will only be shown once, and it will never be shown to you again. Copy and paste this token for yourself, and use this PAT when adding the connection in Make.
p.s. I am the #1 Airtable/Make expert in the entire Airtable community. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld