Skip to content
This repository was archived by the owner on Mar 26, 2026. It is now read-only.

v0.3.0

Choose a tag to compare

@DenisCarriere DenisCarriere released this 22 Mar 19:16
· 11 commits to main since this release
  • Update substreams@v0.4.x dependency
Usage: substreams-sink-sheets [options] [command]

Options:
  -v, --version                          version for substreams-sink-sheets
  -h, --help                             display help for command

Commands:
  run [options] <spkg> <spreadsheet-id>  Push data from a Substreams DatabaseChanges map output to a Google Sheets spreadsheet
  list <spkg>                            List all compatible output modules for a given Substreams package
  create [options]                       Create a new Google Sheets spreadsheet and return the ID
  completion                             Generate the autocompletion script for the specified shell
  help                                   Display help for command

Run

Usage: substreams-sink-sheets run [options] <spkg> <spreadsheet-id>

Push data from a Substreams DatabaseChanges map output to a Google Sheets spreadsheet

Arguments:
  spkg                                    URL or IPFS hash of Substreams package
  spreadsheet-id                          ID of Google Sheets spreadsheet to write output to (i.e.
                                          https://docs.google.com/spreadsheets/d/{ID}/edit)

Options:
  -m --output-module <string>             Name of the output module (declared in the manifest) (default: "db_out")
  -e --substreams-endpoint <string>       Substreams gRPC endpoint to stream data from (default:
                                          "https://mainnet.eth.streamingfast.io:443")
  -s --start-block <int>                  Start block to stream from (defaults to -1, which means the initialBlock of the first
                                          module you are streaming)
  -t --stop-block <string>                Stop block to end stream at, inclusively
  -c --columns <items>                    Output columns filter as a comma-separated list (default: [])
  --add-header-row                        Add the name of the columns to the first row of the spreadsheet (default: false)
  --range <string>                        The A1 notation of the table range (default: "Sheet1")
  --access-token <string>                 Google OAuth2 access token
  --refresh-token <string>                Google OAuth2 refresh token
  --service-account-file <string>         Google Service account keys JSON file
  --substreams-api-token <string>         API token for the substream endpoint
  --substreams-api-token-envvar <string>  Environnement variable name of the API token for the substream endpoint (default:
                                          "SUBSTREAMS_API_TOKEN")
  -h, --help                              display help for command