Import raw CSV text directly into a Google Sheet using batchUpdate's PasteDataRequest instead of pre-parsing it client-side.

Documented steps

1. POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate with OAuth scope https://www.googleapis.com/auth/spreadsheets (or drive/drive.file); body: {"requests": [{"pasteData": { ... }}]}.
2. Set pasteData.coordinate to a GridCoordinate object, e.g. {"sheetId": 0, "rowIndex": 0, "columnIndex": 0}, marking the top-left cell where the CSV should land.
3. Set pasteData.data to the raw CSV text as one string (e.g. "a,b,c\n1,2,3"), and pasteData.delimiter to the delimiter character used in it (e.g. ",").
4. Set pasteData.type to a PasteType enum value: PASTE_NORMAL pastes values, formulas, formats, and merges; PASTE_VALUES pastes only the raw values with no formatting, formulas, or merges.
5. Leave pasteData.html false (or omit it) for plain delimited CSV text; only set it true if pasteData.data instead contains HTML table markup to parse.
6. Sheets auto-expands the sheet's row/column count to fit the pasted data starting at the given coordinate; no separate dimension-insert call is needed first.
7. Docs: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request | https://developers.google.com/workspace/sheets/api/limits