Skip to main content
Question

Adding Information from an existing table from Google forms/ sheets

  • November 4, 2025
  • 2 replies
  • 25 views
V
Forum|alt.badge.img+1

Hello!

 

I have a table which is sort of like a job application portal for our company. We have a google form which is filled along with roles and role specific questions which then we bring into airtable for screening.

 

Now we wish to have a technical round (Round 1) which is through a seperate google form. I wanted help to get the score from the google form/google sheet into this application portal.

 

As i understand there will be separate source data for the application form and for the Round 1 evaluation form (Seperate google sheets). Hence there might need to be some automation required to be able to match the data of both the sources and add it to the same table. I intend to use the email ID as the matching parameters since the forms are filled using google accounts.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9770 replies
  • November 4, 2025

I’m not sure I understand your question, but it sounds like you want your second form to be able to update a record in Airtable that was submitted by the first form?

You can do this with either Airtable’s automations or Make’s automations (for more advanced automations), but in general, you wouldn’t want to use Google Forms for these sorts of things.

You would typically want to use Fillout’s advanced forms for Airtable because it communicates directly with Airtable and it lets you update existing Airtable records directly with a form.

I show how to set this up on Airtable podcast episode:

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

TheTimeSavingCo
Forum|alt.badge.img+31

Can you make the primary field of your Applicants table be the email of each applicant like so?



If so, you’d have an automation that would trigger whenever a new row gets created in your Sheet (i.e. whenever a new form submission comes through), and its action would be to create a new record to log the details of the submission, and also to paste the Email Address into the linked field to the Applicants table:

This would automatically link the records together for you

---

If you can’t make the primary field of Applicants be the Email, then you’d use a Find Record step to look for the record in Applicants with the right email and then link it together and it’d look something like this:

 

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement