logo-darkpipe0
Go

Google Sheets rows

Import the rows of a Google Sheets tab. Columns come from the tab's header row (or its native Table), with types inferred from the values.

rows:googlesheets@1
Free

ProviderBillingConnectionCost
Docs
GoGoogle Sheets
Per pageUser
n/a

Dynamic output fields

This search's output columns are determined at run time and depend on the data source. Enable config.field_definitions.enabled to receive the columns alongside your results in the response field_definitions.

const options = {
  method: 'POST',
  headers: {'content-type': 'application/json', authorization: 'Bearer <TOKEN>'},
  body: JSON.stringify({
    search: {
      search_id: 'rows:googlesheets@1',
      connector: {
        strategy: 'first',
        connections: [{type: 'vault', connection: 'googlesheets_jane_1a2b'}]
      },
      config: {
        spreadsheet: 'https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0',
        tab: '',
        dedup_columns: ['Email'],
        limit: 100000,
        cursor: null
      }
    }
  })
};

fetch('https://api.pipe0.com/v1/search/run', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));
import requests

url = "https://api.pipe0.com/v1/search/run"

payload = { "search": {
        "search_id": "rows:googlesheets@1",
        "connector": {
            "strategy": "first",
            "connections": [
                {
                    "type": "vault",
                    "connection": "googlesheets_jane_1a2b"
                }
            ]
        },
        "config": {
            "spreadsheet": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0",
            "tab": "",
            "dedup_columns": ["Email"],
            "limit": 100000,
            "cursor": None
        }
    } }
headers = {
    "content-type": "application/json",
    "authorization": "Bearer <TOKEN>"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)
curl --request POST \
     --url https://api.pipe0.com/v1/search/run \
     --header 'authorization: Bearer <TOKEN>' \
     --header 'content-type: application/json' \
     --data '
{
  "search": {
    "search_id": "rows:googlesheets@1",
    "connector": {
      "strategy": "first",
      "connections": [
        {
          "type": "vault",
          "connection": "googlesheets_jane_1a2b"
        }
      ]
    },
    "config": {
      "spreadsheet": "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0",
      "tab": "",
      "dedup_columns": [
        "Email"
      ],
      "limit": 100000,
      "cursor": null
    }
  }
}
'
package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.pipe0.com/v1/search/run"

	payload := strings.NewReader("{\"search\":{\"search_id\":\"rows:googlesheets@1\",\"connector\":{\"strategy\":\"first\",\"connections\":[{\"type\":\"vault\",\"connection\":\"googlesheets_jane_1a2b\"}]},\"config\":{\"spreadsheet\":\"https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0\",\"tab\":\"\",\"dedup_columns\":[\"Email\"],\"limit\":100000,\"cursor\":null}}}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("content-type", "application/json")
	req.Header.Add("authorization", "Bearer <TOKEN>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://api.pipe0.com/v1/search/run', [
  'body' => '{"search":{"search_id":"rows:googlesheets@1","connector":{"strategy":"first","connections":[{"type":"vault","connection":"googlesheets_jane_1a2b"}]},"config":{"spreadsheet":"https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0","tab":"","dedup_columns":["Email"],"limit":100000,"cursor":null}}}',
  'headers' => [
    'authorization' => 'Bearer <TOKEN>',
    'content-type' => 'application/json',
  ],
]);

echo $response->getBody();
POST /v1/search/run HTTP/1.1

Content-Type: application/json

Authorization: Bearer <TOKEN>

Host: api.pipe0.com

Content-Length: 336



{"search":{"search_id":"rows:googlesheets@1","connector":{"strategy":"first","connections":[{"type":"vault","connection":"googlesheets_jane_1a2b"}]},"config":{"spreadsheet":"https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0","tab":"","dedup_columns":["Email"],"limit":100000,"cursor":null}}}