Google Sheets Assistant

Work with your spreadsheets in plain language through the official Google Sheets API.

• Read data: read any range or tab as displayed values or as raw formulas.

• Write data: write, append and clear cells and ranges, including large data sets, with formulas and dates interpreted correctly.

• Spreadsheets and tabs: create spreadsheets and add, rename, duplicate, copy or delete tabs.

• Formatting: number and date formats, fonts, colors, borders, merged cells, alternating row colors and conditional formatting.

• Clean and organize: sort, filter, dropdowns and data validation, find and replace, remove duplicates, split text to columns and protect ranges.

• Charts and named ranges: create and update charts and define named ranges.

• Layout planning: propose a sheet structure with tabs and column headers for your use case.

Examples:

• "What's in Sheet1!A1:D50 of my budget spreadsheet?"

• "Append these rows to the Leads tab."

• "Format column C as currency and bold the header row."

• "Add a column chart of sales by month from A1:B13."

Requires connecting your Google account (OAuth).