Permissions

To safeguard your APIs, it's advisable to grant the minimum necessary permissions required for your application to function effectively. For instance, if your intention is to use the API for data collection through a form, consider assigning only the Update permission. By doing so, even if someone discovers your endpoint, they won't have the capability to view your data.

Following are different permissions we support

• Read : Grants the ability to view and retrieve data from a sheet. Users with this permission can access the data but cannot modify it in any way.
• Apply Filters: Allows users to apply filters on the data. Useful for narrowing down large datasets based on specific conditions without altering the actual data.
• Insert: Enables users to add new rows to the sheet. This includes submitting new data entries through forms, APIs, or the dashboard UI.
• Update: Allows users to modify existing rows in the sheet. They can change values in one or more columns for a given record.
• Delete: Grants permission to permanently delete rows from the sheet. This action removes the data and cannot be undone unless backups or versioning are enabled.
• Clear: Allows users to clear all data from a sheet without deleting the sheet itself. The structure (columns and headers) remains intact, but the content is wiped.
• Add Sheet: Enables users to create new sheets within the current spreadsheet.
• Delete Sheet: Grants permission to permanently delete an entire sheet within a spreadsheet and all of its data

Accessing an unauthorized endpoint will result in a 403 Forbidden error."