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.35k stars 3.72k forks source link

[Epic]: Limit GSheets Access #20155

Closed rohan-arthur closed 1 year ago

rohan-arthur commented 1 year ago

Objective

PRD link

The hypothesis is that appsmith asks for too much authorization, and asks for :

  1. my entire google drive, all files not just spreadsheets
  2. all my spreadsheets

Screenshot 2022-12-16 at 10.50.09.png

This is obviously a problem, and there is a burden of trust that the user is expected to place on appsmith - this represents friction in first setting up a valid datasource.

Having a **valid** datasource, however has been the most important contributing factor to the success of gsheets queries (17/30 smartlook recordings showed an invalid datasource to be the reason for the dropoff seen [here](https://mixpanel.com/project/2032485/view/178891/app/dashboards#id=1160693&editor-card-id=%22report-31187824%22))

Google sheets represents the lowest barrier of entry for app creation on Appsmith. Most times, the user simply has a single useful google sheet that they want to transform into an app. With the gsheets datasource, it should be possible to authorize appsmith to access a single google sheet, instead of the entire drive’s contents.

This idea has already been validated in a [PoC](https://www.notion.so/8ca6c3dfeaba47509acc35282887b0a8)

Success Metrics

Metric
Increase conversion from 45% to 75% here

Prioritised User Stories

No response

Developer Handoff Document in Figma

No response

Test Plan

No response

RACI matrix

| ------------- | ------------- | | Responsible | @sneha122 | | Accountable | @sneha122 | | Consulted | @Nikhil-Nandagopal, @mohanarpit, @areyabhishek| | Informed | |

rohan-arthur commented 1 year ago

zenhub wasn't recognizing this, so created another one: https://github.com/appsmithorg/appsmith/issues/20191