{"id":1341,"date":"2024-09-11T09:09:21","date_gmt":"2024-09-11T08:09:21","guid":{"rendered":"https:\/\/france.magicsoftware.com\/blog\/?p=1341"},"modified":"2025-03-04T17:47:07","modified_gmt":"2025-03-04T16:47:07","slug":"google-spreadsheet-magic-xpi","status":"publish","type":"post","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/","title":{"rendered":"Google SpreadSheet &#8211; Magic xpi"},"content":{"rendered":"\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>Goal<\/strong> : How to handle Google SpreadSheet with Magic xpi using REST Google API<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2\/ Create a new project \u00ab\u00a0SpreadSheet\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"278\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets2-1024x278.png\" alt=\"\" class=\"wp-image-1355\" style=\"width:820px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets2-1024x278.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets2-300x81.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets2-768x209.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets2-1536x417.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets2.png 1823w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"420\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets4-1-1024x420.png\" alt=\"\" class=\"wp-image-1363\" style=\"width:819px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets4-1-1024x420.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets4-1-300x123.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets4-1-768x315.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets4-1-1536x631.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets4-1.png 1885w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"392\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5-1024x392.png\" alt=\"\" class=\"wp-image-1366\" style=\"width:823px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5-1024x392.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5-300x115.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5-768x294.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5.png 1509w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">4\/ Choose credentials Define an OAuth client ID with type Desktop Application <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"366\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5_-1024x366.png\" alt=\"\" class=\"wp-image-1390\" style=\"width:677px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5_-1024x366.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5_-300x107.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5_-768x274.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5_.png 1192w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You need to set the scope to : <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>https:\/\/www.googleapis.com\/auth\/spreadsheets and https:\/\/www.googleapis.com\/auth\/drive<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"445\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5__-1024x445.png\" alt=\"\" class=\"wp-image-1393\" style=\"width:623px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5__-1024x445.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5__-300x130.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5__-768x334.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5__-1536x667.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets5__.png 1902w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"311\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets6-1024x311.png\" alt=\"\" class=\"wp-image-1371\" style=\"width:829px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets6-1024x311.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets6-300x91.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets6-768x233.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets6-1536x467.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets6.png 1885w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Keep the client Id and ClientSecret and the call Back URL (http:\/\/localhost)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5\/ Check with Postman that you can interact with a Google Sheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fill all the relevant informations to get the Access Token and execute a Put operation<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"867\" height=\"917\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets8.png\" alt=\"\" class=\"wp-image-1377\" style=\"width:338px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets8.png 867w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets8-284x300.png 284w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets8-768x812.png 768w\" sizes=\"auto, (max-width: 867px) 100vw, 867px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"628\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets9-1024x628.png\" alt=\"\" class=\"wp-image-1380\" style=\"width:495px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets9-1024x628.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets9-300x184.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets9-768x471.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets9.png 1211w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">6\/ Define a REST Client resource in a magic xpi project<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"603\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets10-1-1024x603.png\" alt=\"\" class=\"wp-image-1387\" style=\"width:590px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets10-1-1024x603.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets10-1-300x177.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets10-1-768x452.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets10-1.png 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Call Back URL must be in our case :   <strong>http:\/\/localhost<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fill the Client id and Client Secret.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set the Authorization URL to :  https:\/\/accounts.google.com\/o\/oauth2\/auth<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set the Access Token URL to : https:\/\/oauth2.googleapis.com\/token<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set the scope to : <strong>https:\/\/www.googleapis.com\/auth\/spreadsheets https:\/\/www.googleapis.com\/auth\/drive<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click on Access Token to acquire the Token<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"829\" height=\"432\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets11.png\" alt=\"\" class=\"wp-image-1400\" style=\"width:497px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets11.png 829w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets11-300x156.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets11-768x400.png 768w\" sizes=\"auto, (max-width: 829px) 100vw, 829px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Sign with you gmail account then you will be redirected to a page and choose go to Spreadsheet at the bottom<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1010\" height=\"641\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets12.png\" alt=\"\" class=\"wp-image-1403\" style=\"width:380px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets12.png 1010w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets12-300x190.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets12-768x487.png 768w\" sizes=\"auto, (max-width: 1010px) 100vw, 1010px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">And confirm the access<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets13-1024x669.png\" alt=\"\" class=\"wp-image-1407\" style=\"width:540px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets13-1024x669.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets13-300x196.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets13-768x502.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets13.png 1263w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"223\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets14-1024x223.png\" alt=\"\" class=\"wp-image-1409\" style=\"width:591px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets14-1024x223.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets14-300x65.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets14-768x167.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets14.png 1475w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"689\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets15-1024x689.png\" alt=\"\" class=\"wp-image-1411\" style=\"width:468px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets15-1024x689.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets15-300x202.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets15-768x516.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets15.png 1160w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Define Paths that you want to interact with the API (use {} to use parameter)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"577\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets17-1024x577.png\" alt=\"\" class=\"wp-image-1421\" style=\"width:635px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets17-1024x577.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets17-300x169.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets17-768x433.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets17.png 1374w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can use Google Workspace explorer ( Sheet API) to test and to get the different paths (https:\/\/developers.google.com\/workspace\/)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"616\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets16-1024x616.png\" alt=\"\" class=\"wp-image-1415\" style=\"width:531px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets16-1024x616.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets16-300x180.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets16-768x462.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets16-1536x923.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets16.png 1567w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Google Sheet API specification can be found at https:\/\/sheets.googleapis.com\/$discovery\/rest?version=v4<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7\/ To get a Google SpreadSheet, Drag and Drop a REST Client connector<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Configure the connector to GET a SpreadSheet<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets18-1024x596.png\" alt=\"\" class=\"wp-image-1425\" style=\"width:531px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets18-1024x596.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets18-300x174.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets18-768x447.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets18.png 1145w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Set {endpath} parameter to 1KSrbWrBezXI437ZgdJAozE8tssdj6OtRnJyimsBwRAw\/values\/A2%3AB (<strong>&lt;sheetid&gt;\/values\/&lt;range&gt;<\/strong>)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"440\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets19-1024x440.png\" alt=\"\" class=\"wp-image-1426\" style=\"width:628px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets19-1024x440.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets19-300x129.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets19-768x330.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets19.png 1443w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After flow execution, you should receive the result in a a json format<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"525\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets20-1024x525.png\" alt=\"\" class=\"wp-image-1429\" style=\"width:640px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets20-1024x525.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets20-300x154.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets20-768x394.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets20-1536x787.png 1536w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets20.png 1734w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">8\/ To send data to a Google SpreadSheet<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Build a json request in the format below (use a datamapper for this step)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">{\u00ab\u00a0values\u00a0\u00bb: [[\u00ab\u00a0ALEM\u00a0\u00bb,\u00a0\u00bbJOHN\u00a0\u00bb],[\u00ab\u00a0DAVID\u00a0\u00bb,\u00a0\u00bbISNER\u00a0\u00bb],[\u00ab\u00a0MAHER\u00a0\u00bb,\u00a0\u00bbMETHENY\u00a0\u00bb],[\u00ab\u00a0ROSS\u00a0\u00bb,\u00a0\u00bbHARRIS\u00a0\u00bb]]}<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Configure the REST Client connector for PUT operation and set {upload} parameter to 1KSrbWrBezXI437ZgdJAozE8tssdj6OtRnJyimsBwRAw\/values\/A2%3AB (<strong>&lt;sheetid&gt;\/values\/&lt;range&gt;<\/strong>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pass the Blob Json request to DataBlob<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"552\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets22-1024x552.png\" alt=\"\" class=\"wp-image-1438\" style=\"width:653px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets22-1024x552.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets22-300x162.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets22-768x414.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets22.png 1216w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You should receive this type of JSON response<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets21-1024x768.png\" alt=\"\" class=\"wp-image-1435\" style=\"width:562px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets21-1024x768.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets21-300x225.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets21-768x576.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets21.png 1196w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"935\" height=\"434\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets23.png\" alt=\"\" class=\"wp-image-1443\" style=\"width:461px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets23.png 935w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets23-300x139.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets23-768x356.png 768w\" sizes=\"auto, (max-width: 935px) 100vw, 935px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">9\/ To clear data, do a <strong>POST<\/strong> with this parameter in the URL<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>https:\/\/sheets.googleapis.com\/v4\/spreadsheets\/&lt;SpreadSheetId&gt;\/values\/&lt;Range&gt;:clear<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">with empty json {}<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">example fill the {endpath} parameter with : 1KSrbWrBezXI437ZgdJAozE8tssdj6OtRnJyimsBwRAw\/values\/A4%3AB:clear<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">and leave the DataBlob empty<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"779\" height=\"651\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets25.png\" alt=\"\" class=\"wp-image-1466\" style=\"width:391px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets25.png 779w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets25-300x251.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets25-768x642.png 768w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets24-1024x596.png\" alt=\"\" class=\"wp-image-1461\" style=\"width:695px;height:auto\" srcset=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets24-1024x596.png 1024w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets24-300x175.png 300w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets24-768x447.png 768w, https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets24.png 1229w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">10\/ Relevant links<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/sheets.googleapis.com\/$discovery\/rest?version=v4\">https:\/\/sheets.googleapis.com\/$discovery\/rest?version=v4<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/developers.google.com\/workspace\">https:\/\/developers.google.com\/workspace<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project \u00ab\u00a0SpreadSheet\u00a0\u00bb 3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1344,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[43,4,44],"tags":[45,14],"class_list":["post-1341","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google","category-magic-xpi","category-sheets","tag-sheets","tag-magic-xpi"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project &quot;SpreadSheet&quot; 3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Sa\u00e2d Alem\"\/>\n\t<meta name=\"google-site-verification\" content=\"5yLZLt_RgZVqkETQDrOlMUHaNTra2i5W8dtHQoCMueY\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Le Blog Techno | Magic Software France\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno\" \/>\n\t\t<meta property=\"og:description\" content=\"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project &quot;SpreadSheet&quot; 3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico\" \/>\n\t\t<meta property=\"og:image:width\" content=\"16\" \/>\n\t\t<meta property=\"og:image:height\" content=\"16\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-09-11T08:09:21+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-03-04T16:47:07+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MagicSoftwareEnterprises\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@MagicSoftware\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project &quot;SpreadSheet&quot; 3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@MagicSoftware\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#blogposting\",\"name\":\"Google SpreadSheet \\u2013 Magic xpi | Le Blog Techno\",\"headline\":\"Google SpreadSheet &#8211; Magic xpi\",\"author\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/GoogleSheets1.png\",\"width\":537,\"height\":128},\"datePublished\":\"2024-09-11T09:09:21+01:00\",\"dateModified\":\"2025-03-04T17:47:07+01:00\",\"inLanguage\":\"fr-FR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#webpage\"},\"articleSection\":\"Google, Magic xpi, Sheets, Google, Magic xpi\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog#listItem\",\"position\":1,\"name\":\"Domicile\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/#listItem\",\"name\":\"Magic xpi\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/#listItem\",\"position\":2,\"name\":\"Magic xpi\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/#listItem\",\"name\":\"Google\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog#listItem\",\"name\":\"Domicile\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/#listItem\",\"position\":3,\"name\":\"Google\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/sheets\\\/#listItem\",\"name\":\"Sheets\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/#listItem\",\"name\":\"Magic xpi\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/sheets\\\/#listItem\",\"position\":4,\"name\":\"Sheets\",\"item\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/sheets\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#listItem\",\"name\":\"Google SpreadSheet &#8211; Magic xpi\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/#listItem\",\"name\":\"Google\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#listItem\",\"position\":5,\"name\":\"Google SpreadSheet &#8211; Magic xpi\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/category\\\/magic-xpi\\\/google\\\/sheets\\\/#listItem\",\"name\":\"Sheets\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#organization\",\"name\":\"Blog Magic France\",\"description\":\"Magic Software France\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/\",\"telephone\":\"+33149105858\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Magic.ico\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#organizationLogo\",\"width\":16,\"height\":16},\"image\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/MagicSoftwareEnterprises\",\"https:\\\/\\\/twitter.com\\\/MagicSoftware\",\"https:\\\/\\\/youtube.com\\\/MagicSoftware\",\"https:\\\/\\\/linkedin.com\\\/company\\\/magic-software-enterprises\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/\",\"name\":\"Sa\\u00e2d Alem\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/38fae53569553d87ce6ffb3b936e4df6feecf6069ddb238526105d8d906273c4?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Sa\\u00e2d Alem\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#webpage\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/\",\"name\":\"Google SpreadSheet \\u2013 Magic xpi | Le Blog Techno\",\"description\":\"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\\\/ Connect to Google Developer Console (https:\\\/\\\/console.cloud.google.com) with your gmail account 2\\\/ Create a new project \\\"SpreadSheet\\\" 3\\\/ Choose APIs & services => Library and choose Sheets and enable it 4\\\/ Choose credentials Define an OAuth client ID with type Desktop\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/author\\\/saad\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/GoogleSheets1.png\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#mainImage\",\"width\":537,\"height\":128},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/magic-xpi\\\/google-spreadsheet-magic-xpi\\\/#mainImage\"},\"datePublished\":\"2024-09-11T09:09:21+01:00\",\"dateModified\":\"2025-03-04T17:47:07+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/\",\"name\":\"Blog Magic France\",\"description\":\"Magic Software France\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/france.magicsoftware.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno","description":"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project \"SpreadSheet\" 3\/ Choose APIs & services => Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop","canonical_url":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"5yLZLt_RgZVqkETQDrOlMUHaNTra2i5W8dtHQoCMueY","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#blogposting","name":"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno","headline":"Google SpreadSheet &#8211; Magic xpi","author":{"@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author"},"publisher":{"@id":"https:\/\/france.magicsoftware.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets1.png","width":537,"height":128},"datePublished":"2024-09-11T09:09:21+01:00","dateModified":"2025-03-04T17:47:07+01:00","inLanguage":"fr-FR","mainEntityOfPage":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#webpage"},"isPartOf":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#webpage"},"articleSection":"Google, Magic xpi, Sheets, Google, Magic xpi"},{"@type":"BreadcrumbList","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog#listItem","position":1,"name":"Domicile","item":"https:\/\/france.magicsoftware.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/#listItem","name":"Magic xpi"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/#listItem","position":2,"name":"Magic xpi","item":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/#listItem","name":"Google"},"previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog#listItem","name":"Domicile"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/#listItem","position":3,"name":"Google","item":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/sheets\/#listItem","name":"Sheets"},"previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/#listItem","name":"Magic xpi"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/sheets\/#listItem","position":4,"name":"Sheets","item":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/sheets\/","nextItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#listItem","name":"Google SpreadSheet &#8211; Magic xpi"},"previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/#listItem","name":"Google"}},{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#listItem","position":5,"name":"Google SpreadSheet &#8211; Magic xpi","previousItem":{"@type":"ListItem","@id":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/sheets\/#listItem","name":"Sheets"}}]},{"@type":"Organization","@id":"https:\/\/france.magicsoftware.com\/blog\/#organization","name":"Blog Magic France","description":"Magic Software France","url":"https:\/\/france.magicsoftware.com\/blog\/","telephone":"+33149105858","logo":{"@type":"ImageObject","url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#organizationLogo","width":16,"height":16},"image":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/MagicSoftwareEnterprises","https:\/\/twitter.com\/MagicSoftware","https:\/\/youtube.com\/MagicSoftware","https:\/\/linkedin.com\/company\/magic-software-enterprises"]},{"@type":"Person","@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author","url":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/","name":"Sa\u00e2d Alem","image":{"@type":"ImageObject","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/38fae53569553d87ce6ffb3b936e4df6feecf6069ddb238526105d8d906273c4?s=96&d=mm&r=g","width":96,"height":96,"caption":"Sa\u00e2d Alem"}},{"@type":"WebPage","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#webpage","url":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/","name":"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno","description":"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project \"SpreadSheet\" 3\/ Choose APIs & services => Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/france.magicsoftware.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#breadcrumblist"},"author":{"@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author"},"creator":{"@id":"https:\/\/france.magicsoftware.com\/blog\/author\/saad\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets1.png","@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#mainImage","width":537,"height":128},"primaryImageOfPage":{"@id":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/#mainImage"},"datePublished":"2024-09-11T09:09:21+01:00","dateModified":"2025-03-04T17:47:07+01:00"},{"@type":"WebSite","@id":"https:\/\/france.magicsoftware.com\/blog\/#website","url":"https:\/\/france.magicsoftware.com\/blog\/","name":"Blog Magic France","description":"Magic Software France","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/france.magicsoftware.com\/blog\/#organization"}}]},"og:locale":"fr_FR","og:site_name":"Le Blog Techno | Magic Software France","og:type":"article","og:title":"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno","og:description":"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project &quot;SpreadSheet&quot; 3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop","og:url":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/","og:image":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico","og:image:secure_url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico","og:image:width":16,"og:image:height":16,"article:published_time":"2024-09-11T08:09:21+00:00","article:modified_time":"2025-03-04T16:47:07+00:00","article:publisher":"https:\/\/www.facebook.com\/MagicSoftwareEnterprises","twitter:card":"summary_large_image","twitter:site":"@MagicSoftware","twitter:title":"Google SpreadSheet \u2013 Magic xpi | Le Blog Techno","twitter:description":"Goal : How to handle Google SpreadSheet with Magic xpi using REST Google API 1\/ Connect to Google Developer Console (https:\/\/console.cloud.google.com) with your gmail account 2\/ Create a new project &quot;SpreadSheet&quot; 3\/ Choose APIs &amp; services =&gt; Library and choose Sheets and enable it 4\/ Choose credentials Define an OAuth client ID with type Desktop","twitter:creator":"@MagicSoftware","twitter:image":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2023\/11\/Magic.ico"},"aioseo_meta_data":{"post_id":"1341","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-09-11 07:56:46","updated":"2025-06-04 06:07:59","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\" title=\"Domicile\">Domicile<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/\" title=\"Magic xpi\">Magic xpi<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/\" title=\"Google\">Google<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/sheets\/\" title=\"Sheets\">Sheets<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tGoogle SpreadSheet \u2013 Magic xpi\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Domicile","link":"https:\/\/france.magicsoftware.com\/blog"},{"label":"Magic xpi","link":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/"},{"label":"Google","link":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/"},{"label":"Sheets","link":"https:\/\/france.magicsoftware.com\/blog\/category\/magic-xpi\/google\/sheets\/"},{"label":"Google SpreadSheet &#8211; Magic xpi","link":"https:\/\/france.magicsoftware.com\/blog\/magic-xpi\/google-spreadsheet-magic-xpi\/"}],"jetpack_featured_media_url":"https:\/\/france.magicsoftware.com\/blog\/wp-content\/uploads\/2024\/09\/GoogleSheets1.png","_links":{"self":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/1341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/comments?post=1341"}],"version-history":[{"count":65,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/1341\/revisions"}],"predecessor-version":[{"id":2888,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/posts\/1341\/revisions\/2888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media\/1344"}],"wp:attachment":[{"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/media?parent=1341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/categories?post=1341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/france.magicsoftware.com\/blog\/wp-json\/wp\/v2\/tags?post=1341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}