Documentation

    Google Sheets

    Read a tab from a Google spreadsheet into a Strata flow. Write results to a spreadsheet, or save them as a file in Google Drive.

    Before you start

    • A Google account.
    • Permission Oplema asks for: drive.file. Oplema can only reach files you pick in Google's file picker and files it creates. Selecting a folder doesn't grant access to what's inside it.
    • No Google Cloud setup is needed.
    • Sheet data travels through Oplema's servers, not directly from your browser. Only Google's file picker runs in your browser. Contact us if your organization's Google settings block the connection.

    Connect

    1. In Strata, select an Input block to read, or an Output block to write.
    2. Set Source to Connectors. On an Output block the same control is Destination.
    3. In the connector dropdown below it, choose Google Sheets.
    4. Open the Connection dropdown and choose Create new connection.
    5. Set Name (optional). Without a name, the connection is labeled google plus the date and time, so a name helps if you have several.
    6. Select Connect to Google Sheets. Google's own sign-in opens in a popup. Approve access there.

    The popup closes, the new connection is selected and the pickers below it load. If access later expires or you need more permissions, select the connection, then select Reconnect to Google Sheets.

    BigQuery uses the same kind of Google connection, so both dropdowns list all your Google connections. A connection made for BigQuery doesn't yet have drive.file. Select it, then select Reconnect to Google Sheets; Oplema keeps its existing permissions and adds this one.

    Read

    SettingWhat it does
    SpreadsheetOpens Google's file picker. Only Google Sheets can be read this way, not other Drive files.
    TabThe tab to load. Its used cells are imported.
    AreaAutomatic, or Custom range with a Range such as A1:H500.
    HeadersAutomatic, First row or No header.

    Select Refresh data to read the tab again. To read a CSV or Excel file stored in Drive, download it and use a local file instead.

    Write

    Set Write as to Google Sheet or File.

    Google Sheet

    • New spreadsheet: leave Sheet on Create new spreadsheet, then set Name (default Output), Folder (default My Drive) and Tab name (default Sheet1).
    • Existing spreadsheet: pick it in Sheet, then choose a Tab, or Create new tab with a Tab name.
    • An existing tab: set Write to Replace or Append rows. To append, the tab's header row must match your column names in order.

    Dates must be 1900 or later. Values Sheets can't preserve are written as text.

    File

    • Create new file: set Folder, Filename and Format. Each run creates a new file.
    • Replace selected file: pick a File. Its contents change; its name and location stay. Only uploaded files such as CSV or Excel can be replaced, not Google Docs or Sheets.

    Format offers CSV, compressed CSV, JSON array, JSON Lines, Parquet, Arrow IPC and Excel workbook. Output writes when you run the flow.

    Limits and billing

    • Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. Failed reads aren't charged, and a read stops when your usage runs out.
    • Writes: the first 50 MB of each write is free. After that, each write costs $0.01 per GB from your usage, and a write stops when your usage runs out.
    • A single cell can hold up to 50,000 characters.

    See Billing for who pays and how usage works.

    Troubleshooting

    MessageWhat to do
    Use a rectangular cell range such as A1:H500Fix Range.
    Google Sheets headers must match the output column names and order before appendingRename or reorder columns in Strata, or use Replace.
    Google Sheets tab already exists: <name>Choose that tab, or enter another Tab name.
    Selected Google Sheets tab is missing: <name>The tab was deleted or renamed. Pick it again.
    This Google file or folder is in the trash. Choose another.Restore it in Drive, or choose another.
    You do not have permission to write to this selection.Ask for edit access, or choose something you can edit.
    Choose an uploaded file, such as a CSV or Excel file, to replace.You picked a Google Doc or Sheet. Use Google Sheet mode for sheets.
    Google spreadsheet <id> was created, but export did not finish: <detail>The new spreadsheet exists but is incomplete. Delete it in Drive, or pick it as the target, then run again.
    This transfer exceeds the free 50 MB and the available usage creditsThe read or write passed 50 MB and your usage ran out. Add usage, or move less data.

    Prepare your data. Build it in Strata.

    Strata opens in your browser, with no account.