You need to sign in to do that
Don't have an account?
DHIVYA SENTHIL KUMAR
How do I create the sheet under a folder in My Drive using apex class?
Trying to create an empty Google Sheet under a particular folder in Google Drive.
HttpRequest req3 = new HttpRequest();
req3.setMethod('POST');
req3.setEndpoint('https://sheets.googleapis.com/drive/v4/spreadsheets');
req3.setHeader('Authorization', 'Bearer '+access_token);
req3.setHeader('content-type', 'application/json');
String body3 = '{"name":"name1","title":" '+sheet+' ","mimeType": "application/vnd.google-apps.spreadsheet"}';
req3.setTimeout(60*1000);
req3.setBody(body3);
Http http3 = new Http();
HttpResponse res3 = http3.send(req3);
System.debug('===== Response==='+ res3.getBody());
HttpRequest req3 = new HttpRequest();
req3.setMethod('POST');
req3.setEndpoint('https://sheets.googleapis.com/drive/v4/spreadsheets');
req3.setHeader('Authorization', 'Bearer '+access_token);
req3.setHeader('content-type', 'application/json');
String body3 = '{"name":"name1","title":" '+sheet+' ","mimeType": "application/vnd.google-apps.spreadsheet"}';
req3.setTimeout(60*1000);
req3.setBody(body3);
Http http3 = new Http();
HttpResponse res3 = http3.send(req3);
System.debug('===== Response==='+ res3.getBody());