Home > database >  How can I use google's spreadsheet API to retrieve the date and time a spread sheet is created?
How can I use google's spreadsheet API to retrieve the date and time a spread sheet is created?

Time:10-17

How can I retrieve the time a spreadsheet was created? Using the Google Api Client. The spreadsheet properties of service.spreadsheets().get(spreadsheetId=sheet_id).execute() does not seem to contain it.

CodePudding user response:

Google sheets api cannot retrieve metadata information about a file. Use Files:get of Google drive api instead:

service().files().get(fileId="sheet_id",fields="createdTime").execute()
  • Related