If you want to add data from your Google Sheets directly to your deals in Pipedrive, you can do that using Zapier.
You will need
Getting your accounts ready
To connect your Google Sheets to Zapier, make sure you have created a new sheet for this purpose. You can learn more about getting started with Google Sheets on Zapier, here.
To link your Google Sheets account to Pipedrive, you will need an active Pipedrive account. If you are looking to familiarize yourself with Pipedrive, check here. You can find out about getting started with Pipedrive on Zapier here.
Click here to save new rows in Google Sheets as new deals in Pipedrive.
Now just test the Zap to make sure it works. If you're satisfied, then new data entered on your Google Sheets document will be added as new deals in your Pipedrive account.