I am looking to connect a Google Form to submit information with an ID# into Airtable through automations. Is there a way that when the info and ID number are entered in the form, that the result can drop into the correct row on the Airtable spreadsheet to match the same ID Number that is listed in a column on the spreadsheet?
You can only update records based on Airtable’s internal Record ID, not any other field.
For a no-code way of doing this, the absolute easiest way to update records — based on any field at all (because you can search before updating) — would be to use Integromat or Zapier. These are significantly more advanced automation platforms than Airtable, and they can handle almost any automation scenario that you can think of. They go way beyond what Airtable offers natively.
Note that I would never recommend Zapier to anyone unless they had a very specific reason to use it… Zapier does NOT offer full Airtable support, and it does not have even half the functionality that Integromat offers. Zapier also costs more than Integromat, even though it does so much less.