Source: Yandex Sheets

How to read data from Yandex Sheets by link, sheet name and OAuth token.

The source accepts a link to the document, an optional sheet name, and an OAuth token for private access.

Source: Yandex Sheets — Eofferix
Eofferix interface screenshot: Source: Yandex Sheets

When to use

Use Yandex Tables when the price or balances are maintained in the Yandex cloud table.

Setting procedure

  1. Create a Yandex Sheets source.
  2. Insert a link to the table.
  3. Specify a sheet if you need to read more than the first sheet.
  4. Fill in the OAuth token if the table is closed.
  5. Start receiving the file and check the table preview.

What to check

  • The link is available to the service using the selected access method.
  • The sheet name is the same as the name in the table.
  • After receiving, the required rows and columns are visible.

Notes

  • For a public table, a token may not be needed.
  • Mark headers and exclude lines after receiving the file.