The steps to Google Sheet with Salesforce are as follows:
Step 1: Create an Account on Zapier
First, you need to create an Account on Zapier if you don’t have one.
Go to https://zapier.com and log in to your account or create a new one.
Step 2: Make a Zap
Click on Choose App & Event and choose the app you want to connect with the event you want to perform
Next, create zap page will appear. On the left corner you can edit your zap name. Select the Google Sheet application and in the Event select “New Spreadsheet Row”.
Step 3: Choose the Account.
Select your Google Drive account in Account section and select Spreadsheet from google drive account. Then hit Continue and Click on Test trigger. It will test dummy data from google sheet in Zapier.
Step 4: Select target application
Click on Choose App & Event and choose which app you want the action to be performed with the Action event you want to perform. So, choose Salesforce in App and choose Create Record in action event.
Step 5: Select the Salesforce Account
Choose the Account. Click the Sign-in button to link your salesforce account in the app to Zapier for the first time. If you have previously connected the app to
Zapier, you can select from the dropdown menu of apps.
Step 6: Select the Salesforce Object and then Map the fields
Choose Lead for Salesforce object and then Map fields of your need (Required * fields are mandatory).
Step 7: Activate your Zap
Click on Test Action to test if your action is working or not and Click on Publish Zap to create the Zap.
Activate your zap by clicking on Turn On zap and now you can test your zap. Add a new detail in row of your google spreadsheet and it will create as a new Lead in Salesforce.