Uses a service account with Google so your Bubble app can connect to the API, invisible to your Bubble App users.
This plugin is for when you want your Bubble application to write rows into a Google Sheet. Also you can get and set a cells data - ie use a Google sheet a bit like a database. Also write cell and rows.
You can send Bubble objects directly - the plugin will convert the Bubble objects into a row in your Google sheet. Or you can pass specific values for up to 25 columns.
The trickiest thing is getting your Google permissions setup correctly. Purchase of the plugin comes with reasonable support to get you up and running.
Documentation & Demo -
https://google-sheet-updater.bubbleapps.io/version-testThere are step by step videos below to show you how to set up things on the Google side. Playlist here
https://youtube.com/playlist?list=PLpZXz2W3mS45yN5qbC0TDD1g7D_NZHIhyContact me in the forum @lindsay_knowcode
If you are here you have probably have tried other plugins and tried to use the API connector and found it just too painful - that is why I created this plugin.
It does not use any 3rd party intermediary connection services (like Zapier) - so no additional costs.
This plugin does not try to do every operation to manage a Spreadsheet - it is just for easily getting data out of Bubble into a Google sheet and for easily doing database type operations on Cells and Rows.
Use Cases
You have data being added in Bubble and you want to create a real time log in a Google sheet as data is added. You can use the Plugin like a "log appender" to a google sheet. Eg Restaurant table bookings
You have a list of things in Bubble and they are being updated and added to by the Bubble app - eg a fleet of Trucks and you are updating what they are being loaded with. You can see the current status in Google sheets and the history of changes. This is a list where each item can be access by a row number.
What isn't good for is where you are doing deletes on a Bubble database and updating by row number won't work. The plugin updates by row number - so you need things that don't change row number.
You want to use Google Sheets like a small database and are able to reference your data by a row number and column letter.
If there is something useful you need adding DM me in the forum @lindsay_knowcode
https://bubble.io/contributor/knowcode-1595426107417x822993085097189100 I've over 50 plugins in the Market Place - all my plugins come with reasonable support to get you up and running.
I am the creator of Plan B - Backups for Bubble Apps.
https://planbbackups.ioI create plugins for complex integrations.
Flow Charts - Business diagrams in Bubble
https://bubble.io/plugin/flow-charts-1673968620785x258403360966967300Adobe PDF - with commentings and annotating
https://bubble.io/plugin/adobe-pdf---with-commenting-1633396514551x410372775588659200Etsy -
https://bubble.io/plugin/etsy-integration-1703292143599x255798298638549000Square ACH and Embedded Cards
https://bubble.io/plugin/square-embedded-card--ach-1654618927193x637538826809245700SSH & SFTP
https://bubble.io/plugin/ssh--sftp-commands-1684859796824x533713044810760200Almighty dropzone - upload to GCS, Backblaze, Wasabi, AWS ... and more
https://bubble.io/plugin/upload-gcs-backblaze-wasabi-+++-1648644338633x187011566245249020Postmark - for templates
https://bubble.io/plugin/postmark-template-1639362726262x203274658985279500Google Sheets Get/Insert/Update
https://bubble.io/plugin/google-sheet-get-insert--update-1663938003776x932115872220446700I do a suite of realtime Speech & Audio processing plugins;
Deepgram - realtime speeach to text with diarization
https://bubble.io/plugin/deepgram-realtime-transcription-1676726070867x623253573730041900Speechmatics - realtime voice translation
https://bubble.io/plugin/speechmatics---realtime-translation-1701815413039x813343498074587100ElevenLabs - realtime synthetic voices
https://bubble.io/plugin/elevenlabs-streaming-text-to-voice-1678812542328x297771263648333800AssemblyAI - realtime voice to text
https://bubble.io/plugin/assemblyai-realtime-transcription-1666200218972x408222199372578800Audo Recorder Pausible - with a beautiful visualisation
https://bubble.io/plugin/audio-recorder-pausable-1684661794734x134627875732586500
Built on Bubble
