Airtable + Google Sheets + Softr integration

Free forever.

Use premium features free for 14 days.

Popular automation

Trigger

Record is created

in Airtable

Actions

Create spreadsheet row

in Google Sheets

Create user

in Softr

Trusted by experts at...

1500+

App Integrations

20 Million+

Ready Automations

42,000+

Customers Worldwide

Ready Workflows for Airtable + Google Sheets + Softr integration

Log new members, keep sheets updated, grant portal access, alert your team, and remove access when people leave, all in just one click.

Trigger

Record is created

in Airtable

Actions

Create spreadsheet row

in Google Sheets

Create user

in Softr

Add every new Airtable member to a Google Sheets roster and create their Softr portal login

Every new member added in Airtable gets a Google Sheets row and a Softr login automatically.

New members often need to appear in a spreadsheet and get portal access before their first visit. Doing both by hand means copying names and emails twice, and a missed step leaves someone locked out. This workflow does both the moment the member is added in Airtable.

Trigger

Record is created

in Airtable

Actions

Continue only if membership tier is VIP

in Condition

Create spreadsheet row

in Google Sheets

Create user

in Softr

Add VIP members from Airtable to a Google Sheets list and give them Softr portal access

Only VIP members get logged in Google Sheets and given a Softr portal login.

A community team often needs VIP members handled differently from everyone else. This workflow checks the membership tier first, so only VIP members are added to the sheet and given portal access. Standard members are left alone, which keeps the VIP list accurate.

Trigger

Record is created

in Airtable

Actions

Parse and classify member profile data

in ChatGPT

Create user

in Softr

Create spreadsheet row

in Google Sheets

Let AI sort new Airtable member profiles, then create their Softr login and add them to Google Sheets

AI tidies up each new member's industry and contact details before Softr and Google Sheets get them.

Application forms often arrive with messy job titles, industries and contact details. Sorting them by hand takes time and leads to mixed-up categories. This workflow has AI classify the profile first, then creates the Softr login and adds a clean row to Google Sheets.

Trigger

Record is created

in Airtable

Actions

Create spreadsheet row

in Google Sheets

Create user

in Softr

Send welcome email

in Gmail

Add new Airtable clients to Google Sheets, create their Softr portal login and send a Gmail welcome email

New clients get logged, get portal access and receive a Gmail welcome, all automatically.

A customer portal team needs every new client logged in a spreadsheet and given access before they arrive. Sending each welcome email by hand is easy to forget. This workflow logs the client, creates their login, and sends the welcome email from Gmail at the same time.

Trigger

Record is created

in Airtable

Actions

Search row using column and value

in Google Sheets

Update spreadsheet row

in Google Sheets

Create user

in Softr

When a client is approved in Airtable, update their Google Sheets intake row and create their Softr user

Approved clients get their existing sheet row updated and a Softr user created.

Coaching firms often collect intake details in a spreadsheet long before a client is approved. Adding a second row would split the history. This workflow finds the existing row, updates its status, and then creates the portal user in Softr.

Trigger

Record is created in view

in Airtable

Actions

Create user

in Softr

Create spreadsheet row

in Google Sheets

Give Softr portal access and log the approval in Google Sheets when a vetted client joins the Approved list in Airtable

When a client is marked approved in Airtable, they get a Softr login and a Google Sheets log entry.

Client teams need to know exactly when a client was approved and when their access started. Doing this manually means checking lists and typing into a tracking sheet. This workflow grants portal access and logs the approval as soon as the client appears in the Approved list.

Trigger

Record is created in view

in Airtable

Actions

Continue only if portal access flag is true

in Condition

Create user

in Softr

Create spreadsheet row

in Google Sheets

Create Softr logins for approved Airtable contractors only when portal access is switched on, then log them in Google Sheets

Contractors get a Softr login and a Google Sheets entry only when portal access is switched on in Airtable.

Portal access should only go to contractors who were cleared for it. Giving login details to the wrong person is a security risk. This workflow checks the portal access flag first, then creates the Softr user and logs the approval in Google Sheets.

Trigger

Record is created in view

in Airtable

Actions

Create user

in Softr

Create spreadsheet row

in Google Sheets

Send channel message

in Slack

Create Softr logins for new Airtable clients, log them in Google Sheets and alert your team in Slack

New portal-ready clients trigger a Softr login, a sheet row and a Slack message for the team.

Client success staff need to know as soon as a client can use the portal. Waiting for someone to mention it in a meeting slows down the first contact. This workflow creates access, logs it in Google Sheets, and posts a Slack message so the team sees it right away.

Trigger

Record is created in view

in Airtable

Actions

Delete user

in Softr

Search row using column and value

in Google Sheets

Update spreadsheet row

in Google Sheets

Remove Softr portal access and update the staff sheet when someone is moved to Offboarded in Airtable

Leaving staff lose their Softr login, and their Google Sheets entry is updated to match.

When someone leaves, their portal access should end on the same day. Forgetting to remove a login is a common security gap. This workflow removes the Softr user first, then finds their row in the master sheet and updates it, so the staff list stays accurate.

1of3

Got a different automation in mind? Describe it and let Integrately AI build it for you.

More ways to automate your
Airtable + Google Sheets + Softr workflow

Connect 1,500+ apps and get more done from your workflows.

Send a welcome text

Once a new member is added, Twilio can send them a short text with a welcome note. They get a message on their phone within moments, not an email they might miss.

Send it to accounts

When a payment is confirmed, Xero or QuickBooks can create the matching invoice. Your finance team gets the details without someone copying them across by hand.

Create the next task

When a new client is onboarded, Trello or Asana can create an onboarding task card. Your team can start the first check-in without waiting for a meeting to assign it.

Store onboarding files

Signed forms and contracts can be saved to Dropbox or Google Drive automatically. Each client's paperwork ends up in one folder, ready when someone needs it.

Report on sign-ups

Looker Studio can read your Google Sheets roster and build a simple chart of new members each week. Managers can see growth without asking for an export.

Follow up after 30 days

After a client has been active for a month, Mailchimp can send a check-in email to the people on your list. The follow-up goes out on time without anyone setting reminders.

How the data usually flows between Airtable, Google Sheets and Softr

See how information moves automatically from your signup list through your spreadsheet to your member portal.

Airtable

The moment a new member is added in Airtable, the automation starts. Nobody has to check the list for new people.

New sign-up

Google Sheets

Their name and details are added as a new line in Google Sheets. The roster stays current without copying anything by hand.

Log the member

Softr

Softr creates a user account for them straight away. They can sign in without waiting for someone to set it up.

Portal access

Softr

The new member can sign in and see their portal content the same day. Staff do not need to send login details by hand.

Member is in

Fully Automated

Once set up, your data moves seamlessly
between Airtable, Google Sheets and Softr.

Steps to connect Airtable, Google Sheets and Softr

Log in to Integrately
Search and select Airtable and Google Sheets
Pick a ready 1-click automation or select the desired trigger-action pair
Securely connect your Airtable & Google Sheets accounts
Add Softr in the next steps of your workflow
Map the fields across all three apps
Test it, then switch it on Done

Supported triggers and actions

A trigger is what starts the automation. An action is what it does next. Mix any of these across the three apps.

Airtable Triggers & Actions

Record is created in view in Airtable

Triggers the automation when a record is created in a particular view within an app

Record is created or updated in Airtable

Triggers the automation when a record is created or updated in the particular application

Record is created in Airtable

Triggers the automation when a new record is created

Google Sheets Triggers & Actions

Spreadsheet row is created in Google Sheets

Triggers the automation when a spreadsheet row is created

Spreadsheet row is created or updated in Google Sheets

Triggers the automation when a spreadsheet row is created or updated

Spreadsheet is created in Google Sheets

Triggers the automation when a spreadsheet is created

Worksheet is created in Google Sheets

Triggers the automation when a new worksheet is created

Softr Triggers & Actions

Create user in Softr

Generates a new user account

Delete user in Softr

Removes a user from the system

Try This Integration – No Code Needed

Who this setup is for

Membership organisers

Customer portal teams

Coaching and course teams

HR and staff admins

📋 Membership organisers

Adding new members by hand means copying their details into several places. This setup adds each member to your sheet and creates their portal login.

🎙️ Customer portal teams

Each new client needs a sheet entry and a login before their first visit. This setup logs them and creates their portal account at once.

🔁 Coaching and course teams

Students who pay need portal access, but checking payments takes time. This automation creates the student's login only after payment shows Completed.

🗂️ HR and staff admins

Leaving staff still have portal access long after their last day. This setup removes their login and updates the staff sheet when they leave.

Did you know?

Our team can create automations for you... At no extra cost!

Tell us what type of automation you want to make?

Built in

Everything this automation handles for you