Google Sheets can automatically import data from other websites, and it also includes a form tool, Google Forms, to gather data and save it directly to your spreadsheet. Now, let us try it out by setting up a form to collect lead information from prospective clients. When people click on your link, they can fill out your questions, and the data will be saved to your spreadsheet automatically. First, you will want to add a form to your spreadsheet as a simple way to gather data.
You can read more here: https://zapier.com/learn/google-sheets/spreadsheet-crm/
Besides if you do have any questions give me a call: https://clarity.fm/joy-brotonath