Read, write, and format spreadsheet data — perfect for structured storage, dashboards, and reports
Connect via PincerAPI
Use our proxy to call Google Sheets API with your PincerAPI key. No separate signup needed.
# Get instructions for Google Sheets API
curl -H "Authorization: Bearer YOUR_PINCER_KEY" \
https://pincerapi.com/api/v1/apis/google-sheets/instructions
# Call through PincerAPI proxy
curl -H "Authorization: Bearer YOUR_PINCER_KEY" \
"https://pincerapi.com/api/v1/connect/google-sheets/your/endpoint/here"Direct Setup
Endpoints
/spreadsheets/{spreadsheetId}$0.0000/callGet spreadsheet metadata, sheets, and properties
💡 Auth: OAuth 2.0 with spreadsheets.readonly scope. Spreadsheet ID is in the URL: /spreadsheets/d/{ID}/edit. Use ranges to limit data returned.
/spreadsheets/{spreadsheetId}/values/{range}$0.0000/callRead cell values from a specific range
💡 Returns a 2D array of values. First row is typically headers. Use FORMATTED_VALUE for display-ready data, UNFORMATTED_VALUE for raw numbers.
/spreadsheets/{spreadsheetId}/values/{range}$0.0000/callWrite cell values to a specific range
💡 Use USER_ENTERED to let Sheets parse formulas and dates. RAW writes literal strings. Scope: spreadsheets for read/write.
/spreadsheets/{spreadsheetId}/values/{range}:append$0.0000/callAppend rows to the end of a table in a sheet
💡 Finds the last row of existing data and appends below it. Perfect for logging data. Use INSERT_ROWS to avoid overwriting.
Related APIs in documents-productivity
Airtable
Relational database meets spreadsheet — create, read, update records with rich field types and views
Api2Convert
Online File Conversion API
apilayer pdflayer
HTML/URL to PDF
Clockify
Clockify's REST-based API can be used to push/pull data to/from it & integrate it with other systems
CloudConvert
Online file converter for audio, video, document, ebook, archive, image, spreadsheet, presentation
Cloudmersive Document and Data Conversion
HTML/URL to PDF/PNG, Office documents to PDF, image conversion