appsmithorg / appsmithorg/appsmith

[Feature] Google Drive Integration

Open
#4,304 3 comments 0 reactions 0 assignees View on GitHub
Community Reported Enhancement Integrations Product New Datasource 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

Requesting an additional method for Google Sheets API to fetch an array of all files _(and associated meta-data)_ for a given **folder Id**, instead of _rows_ for a given **sheet Id**. The method should return an array of JSON objects representing all files in the given folder _(matching optional filter conditions)_.

## Motivation

Provide developers the ability to monitor a folder as a data-source, with each row of data being driven by the folder's current list of files and meta-data, including EXIF/Geo-location, dimensions, file size, file type, etc.

## Additional Context

### Use Cases:
- users bulk-upload photos to Google Folder => table populates with multiple rows representing "inspection_photo", "survey_location", "timestamp", "filename", etc
- User captures photo with auto-upload to Google folder already configured. Taking a photo will create a row that captures the user's location, along with the timestamp and photo as a row of data.
- Other script/integration saves email attachments to a folder: `if (Label="X") {saveAttachments ("folderId")}` => view as table in Appsmith
- Google form with file upload => Save files to folder and monitor as data-source

### Similar feature on AppSheet:
[https://help.appsheet.com/en/articles/4865398-folder-data-source-the-essentials](https://help.appsheet.com/en/articles/4865398-folder-data-source-the-essentials)

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.