[Google Workspace] Upload file in Google Sheets

[aeorge]

Extension

https://www.raycast.com/raycast/google-workspace

Description

Almost every time I use the Create Google Spreadsheet feature, my next step is to import a file. This process involves several steps:

1. Click on File → Import
2. Click on "Upload"
3. Drag and drop the file
4. Click on "Import data"

A command that creates a new spreadsheet and uploads the currently selected file in one step would greatly speed up this process.

I can work on this if it fits within the scope of this extension.

Who will benefit from this feature?

Anyone who wants to quickly upload a locally stored file into Google Sheets to continue working on it or invite others to collaborate.

Anything else?

No response

[raycastbot]

Thank you for opening this issue!

🔔 @thomaslombart @mathieudutour @marcmagn1 @mepearso @jbjanot @ridemountainpig you might want to have a look.

💡 Author and Contributors commands

The author and contributors of raycast/google-workspace can trigger bot actions by commenting:

• @raycastbot close this issue Closes the issue.
• @raycastbot close as not planned Closes the issue as not planned.
• @raycastbot rename this issue to "Awesome new title" Renames the issue.
• @raycastbot reopen this issue Reopens the issue.
• @raycastbot assign me Assigns yourself to the issue.
• @raycastbot good first issue Adds the "Good first issue" label to the issue.
• @raycastbot keep this issue open Make sure the issue won't go stale and will be kept open by the bot.

[thomaslombart]

Thanks for the feature request! Unfortunately, it's not possible to do that as of now for two reasons:

1. The Create Google Spreadsheet only opens a URL on your behalf.
2. We don't have write access to your Google Workspace data, and getting it involves going through a verification process by Google which is painful to go through 😕

[aeorge]

I see, thanks for the explanation!

I searched the store and found this extension, which offers a similar feature specifically for Google Docs. Initially it asks for write access and then uses the Google Docs API to write the text into a document.

For spreadsheets, the Google Sheets API could be used instead, which looks similar to the Google Docs API. Another approach would be to use the Google Drive API, which requires fewer requests.

Could this be a possible solution?

[thomaslombart]

That could be a possible solution indeed. I'll have to look at it at some point. Unfortunately, I'm fully focused on another project, so I won't have much bandwidth for that right now 😕