Google Sheets

Send data to Google Sheets with Agentive

---

Creating Google Sheets requires a few additional steps:

1. Go to Google Cloud Console

2. Create a New Project

3. Navigate to APIs & Services, search for the Google Sheets API and enable it.

4. Go to API & Services > Credentials and click + Create Credentials and make new OAuth Client ID

5. Choose Web Application

6. Add https://www.googleapis.com/auth/spreadsheets as a scope.

7. Once you generate your OAuth Client ID you can now use this to make a request in order to generate your Access Token.

8. Make the following request:

curl --request POST "https://oauth2.googleapis.com/token" \
  --header "Content-Type: application/x-www-form-urlencoded" \
  --data "code=YOUR_AUTHORIZATION_CODE" \
  --data "client_id=YOUR_CLIENT_ID" \
  --data "client_secret=YOUR_CLIENT_SECRET" \
  --data "redirect_uri=YOUR_REDIRECT_URI" \
  --data "grant_type=authorization_code"

1. Once you generate your access token you can use this as the authentication for this Tool. Make sure to use Bearer type.

Authorization: Bearer ya29.a0AfH6SMA...

Your spreadsheetID is the red section in the URL when on your Google Sheets:

https://docs.google.com/spreadsheets/d/1mIVTBkkzfdepYahCVuTCENKGxYtZAua1NTgNMYRsPjw/edit?gid=0#gid=0

POST lead information to a Google Sheets

openapi: 3.1.0
info:
  title: Google Sheets Leads API
  description: API for appending lead information to a Google Sheets document using OAuth 2.0 for authentication.
  version: 1.0.0
servers:
  - url: https://sheets.googleapis.com/v4/spreadsheets
    description: Google Sheets API Base URL
paths:
  /SPREADSHEET_ID/values/SHEET_NAME:append:
    post:
      operationId: appendLeadData
      summary: Append lead information to Google Sheets
      description: Appends lead data (Name, Description, Phone Number) to the specified Google Sheets document using OAuth 2.0.
      parameters:
        - name: valueInputOption
          in: query
          required: true
          description: Determines how the input data should be interpreted.
          schema:
            type: string
            enum: [RAW, USER_ENTERED]
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                values:
                  type: array
                  description: The lead information to append, structured as an array of arrays.
                  items:
                    type: array
                    items:
                      type: string
                  example:
                    - ["John Smith", "John is a great candidate and well versed in coding", "[phone]"]
      responses:
        '200':
          description: Data successfully appended to the Google Sheet.
          content:
            application/json:
              schema:
                type: object
                properties:
                  updates:
                    type: object
                    description: Information about the append operation
                    properties:
                      updatedRange:
                        type: string
                        description: The range of the cells that were updated
                      updatedRows:
                        type: integer
                        description: Number of rows updated
                      updatedColumns:
                        type: integer
                        description: Number of columns updated
                      updatedCells:
                        type: integer
                        description: Number of cells updated
        '400':
          description: Bad request or invalid input.
        '401':
          description: Authentication failed.
components:
  securitySchemes:
    oauth2:
      type: oauth2
      description: OAuth 2.0 authentication for accessing Google Sheets API
      flows:
        authorizationCode:
          authorizationUrl: https://accounts.google.com/o/oauth2/auth
          tokenUrl: https://oauth2.googleapis.com/token
          scopes:
            https://www.googleapis.com/auth/spreadsheets: Full access to Google Sheets