function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Aleksandra CzepiergaAleksandra Czepierga 

python simple salesforce - insert data

Hi!
I wanted to use python imple salesforce to get data from google sheet and import it into salesforce. In more details, I want to create tasks with information included in this excel.
Simplifying sth like this:
#sf.Task.create({'WhatId': columnD, 'Subject': columnE })

I don't think i can bulk insert it so I'm thinking how to iterate it but I have issues with iterating through cells.  Have you ever tried to insert sth from gsheet, how?


I have connected to gsheet and pulled data to dataframe.
But what then?
AbhishekAbhishek (Salesforce Developers) 
Hi Aleksandra,

The below blogs have working examples and code snippets for your requirement.

https://towardsdatascience.com/using-python-to-get-salesforce-data-97bb5a7ef2cf

https://jereze.com/code/salesforce-rest-api-python/

I hope you find the above information is helpful. If it does, please mark as Best Answer to help others too.

Thanks.
Pointy MalcolmPointy Malcolm
Get more information here
https://highlights.pointgoals.com