A: Hey!
For your case, you can use the Google Ads "lead form extensions" trigger and the action "create/update a row" in Google Sheets.
If you need help structuring the automation, our support team is on hand to help!