appsmithorg / appsmithorg/appsmith

[Feature] Ability to dynamically add sheets in existing Google spreadsheet

Open
#8,287 4 comments 0 reactions 5 assignees Claimed by @nerbos View on GitHub
Enhancement Google Sheets High Integrations Product Query & JS Pod Query Widgets & IDE Pod
Dominant language
TypeScript
Stars
40.9k
Forks
4.8k
Avg merge
1d 22h
Merged PRs (30d)
45

Description

## Summary

Ability to dynamically create a new sheet (name based on input fields) and insert data into that specific sheet, in Google Sheets

## Motivation

This is useful when there is one topic (therefore all the data should sit in 1 spreadsheet), but there are logically distinct sub topics / different consumers of that information. Instead of creating a new spreadsheet for each of these (which is what is currently possible via Appsmith using the _Create New Spreadsheet_ function), it'd be great to be able to just create sheets in the same spreadsheet. An example in the SAAS world is when as a PM, I need to share the same type of data (say, top users of the app) split out by account - so that i can ask the CS team to do the appropriate follow up in their personal sheets, instead of creating an 'account' column

## Additional Context

I've previously done this with the Gspread python API - i've used this to great effect across a variety of applications.

Front logo [Front conversations](https://app.frontapp.com/open/top_6dkp8)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.