Google API Use Cases-Record Sheets
Number of APIs: 5
-
1. Get Gmail Inbox GET {{baseUrl}}/gmail/v1/users/:userId/messages?maxResults={{maxResults}}&pageToken={{pageToken}}&q={{q}}
-
2. Get GMail Email Details GET {{baseUrl}}/gmail/v1/users/:userId/messages/:id
-
3a. Get Google Sheet if Exist GET {{baseUrl}}/v4/spreadsheets/:spreadsheetId?ranges={{ranges}}&includeGridData={{includeGridData}}&access_token={{accessToken}}&alt={{alt}}&callback={{callback}}&fields={{fields}}&key={{key}}&oauth_token={{oauthToken}}&prettyPrint={{prettyPrint}}"aUser={{quotaUser}}&upload_protocol={{uploadProtocol}}&uploadType={{uploadType}}&$.xgafv={{.Xgafv}}
-
3b. Create Google Sheet if Does Not Exist POST {{baseUrl}}/v4/spreadsheets?access_token={{accessToken}}&alt={{alt}}&callback={{callback}}&fields={{fields}}&key={{key}}&oauth_token={{oauthToken}}&prettyPrint={{prettyPrint}}"aUser={{quotaUser}}&upload_protocol={{uploadProtocol}}&uploadType={{uploadType}}&$.xgafv={{.Xgafv}}
-
4. Append GMail Message Details to Sheet POST {{baseUrl}}/v4/spreadsheets/:spreadsheetId/values/{{range}}:append?valueInputOption={{valueInputOption}}&insertDataOption={{insertDataOption}}&includeValuesInResponse={{includeValuesInResponse}}&responseValueRenderOption={{responseValueRenderOption}}&responseDateTimeRenderOption={{responseDateTimeRenderOption}}&access_token={{accessToken}}&alt={{alt}}&callback={{callback}}&fields={{fields}}&key={{key}}&oauth_token={{oauthToken}}&prettyPrint={{prettyPrint}}"aUser={{quotaUser}}&upload_protocol={{uploadProtocol}}&uploadType={{uploadType}}&$.xgafv={{.Xgafv}}