Salesforce | Salesforce and Google Sheets API Integration Using Named Credential, Apex Callout

[@tosukeshkumar]

Please also make a video how to do reverse, like how to get lead from google sheet to Salesforce.

[@KevinPeters-k7j]

Good video -- could you share that Apex code, that way I don't have to manually copy it into my own org? :D

[@ruchikagedam1762]

nice explanation sir, Thank You!

[@harshsharma2833]

with the from i m getting data in google sheet, and i want all the record which is creating in google sheet direcly add on in my salesforce org

[@sahanab4881]

Hi, instead of Google as auth provider i used Open id connect and followed the same steps. But it gives me error of 401 , unauthorized and gives the error message as ""code":"CanNotReadSecurityToken","message":"The provided authentication token is not valid, Security token is either null or is not well formed Json web token." Any idea about this..

[@itsIs263]

Thank you! Can we do from Excel to salesforce

[@vijayreddyambati1242]

Very Nice... We are trying to get the data from Excel and create a case in Salesforce...

[@winfomi]

Ok. Cool.

[@agomonipaul5359]

@@winfomi i have feteched the data from Google sheet using Rest api named credentials as you have explained. But in the json response it is coming as [ {"majorDimension" : "Rows"}, "Range : "test_sheet!A1:B3"}, {"Values": ["firstname,"Lastname"],["Asha","Roy"],["Ria","Saha"]} ] But I need the values part in proper json format response like {"Firstname" : "Asha " ,"Lastname": "Roy"},{"Firstname" :"Ria","Lastname":"Saha"}

[@agomonipaul5359]

@@winfomi can you kindly help me?

[@hariharannatarajan7208]

@@agomonipaul5359 In a simple way create a wrapper class which replicates the structure of json and use json.deserialize method to change the json format into wrapper class then u can work with your wrapper

[@neelgugale6510]

how to do the exact reverse, where you have client ID and even the paramerets, you need to push leads from google spreasheet to teh rest api?

[@agomonipaul5359]

Did you get the Google sheet response?

[@neelgugale6510]

@@agomonipaul5359 not yet

[@surajbahale9291]

Thank you 😊 i like it

[@royquek8937]

Hi Tamilselvan, understand it has been a long time since this video has been created, but would you have the source code for : GoogleSheet_Sync__c , I believe it is the final step before completion, would be very thankful if you could share it !

[@shubhamchaudhary5916]

GoogleSheet_Sync__c is a checkbox field on contact object to determine if a record is synced or not

[@KavishSharma]

@@shubhamchaudhary5916 hey can you tell me about that confirm button how to create that and how to link it

[@hbtuoputhmebaitrrhho1842]

text