search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
34.3k stars 3.71k forks source link

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

Open shubham-maurya opened 3 years ago

shubham-maurya commented 3 years ago

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

Nikhil-Nandagopal commented 3 years ago

@shubham-maurya thanks for the feature request. IIRC, you're looking for a new method to add a sheet within an existing spreadsheet?

shubham-maurya commented 3 years ago

Hi @Nikhil-Nandagopal, yes thats right

cmeissner commented 1 year ago

Another use case is to have a sheet for every new month to collect data separately. E.g. collecting your spendings per month. At the moment you have either to use a generic name (spendings) and copy it an every month to a separate sheet and empty the spendings sheet. Alternatively you can change the sheet name in the Query. Both is really annoying and a source for faults.

cmeissner commented 1 year ago

I have found a workaround:

  1. Create an apps script with a function that creates your sheets
  2. Deploy the apps script as executable api
  3. Create OAuth 2 login data in the related Google Cloud Project for APIs & services
  4. Create an Authenticated API data source in Appsmith (follow documentation except. 9/iii)
  5. Create corresponding API with json dict for calling the function from 1)

You can now either run the API on each page load or on call.