- Видео 14
- Просмотров 183 218
SheetDB
Добавлен 19 мар 2021
The official channel of SheetDB - a great tool that turns Google Spreadsheet into JSON API.
On this channel you find tutorial videos which will help you discover the awesome features of SheetDB and connect your Google Sheets to CRM, API, Website, WordPress and more applications and tools.
On this channel you find tutorial videos which will help you discover the awesome features of SheetDB and connect your Google Sheets to CRM, API, Website, WordPress and more applications and tools.
Display content of Google Spreadsheet in your website using only HTML, SheetDB + Handlebars script
Discover how to effortlessly display Google Spreadsheet content on your website using just HTML, SheetDB, and Handlebars script! This step-by-step tutorial from SheetDB's channel will guide you through integrating your data into your site with ease. Learn more and elevate your web design game today! 📊🌐 #SheetDB #GoogleSheets #Handlebars #webdesign
Docs:
📖 Library: docs.sheetdb.io/handlebars
💾 Cache: docs.sheetdb.io/cache
🌍 To test our product, visit SheetDB's website: sheetdb.io
✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io
🗞 For more content, visit our blog: blog.sheetdb.io
Docs:
📖 Library: docs.sheetdb.io/handlebars
💾 Cache: docs.sheetdb.io/cache
🌍 To test our product, visit SheetDB's website: sheetdb.io
✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io
🗞 For more content, visit our blog: blog.sheetdb.io
Просмотров: 2 632
Видео
Create Google Spreadsheet and API from JSON data
Просмотров 2,8 тыс.Год назад
Turn Your JSON Data into a Spreadsheet and Generate APIs with SheetDB! 🌍 To test our product, visit SheetDB's website: sheetdb.io ✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io 🗞 For more content, visit our blog: blog.sheetdb.io
Use your Google Spreadsheet data in Laravel, PHP
Просмотров 9 тыс.3 года назад
This new video shows how to work with data in Google Spreadsheet through SheetDB API in PHP, using Laravel. Check our PHP Use Case at SheetDB's website: sheetdb.io/use-cases/google-sheets-json-data-with-php 🌍 To test our product, visit SheetDB's website: sheetdb.io ✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io 🗞 For more content, visit our blog: blog.sheetdb.io
Import JSON to Google Spreadsheet
Просмотров 19 тыс.3 года назад
The video shows how to import data in JSON format directly into Google Sheets via SheetDB API. Link to SheetDB's documentation: docs.sheetdb.io 🌍 To test our product, visit SheetDB's website: sheetdb.io ✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io 🗞 For more content, visit our blog: blog.sheetdb.io
Use UPDATE & DELETE requests on Google Sheets data in Adalo-created app
Просмотров 8 тыс.3 года назад
Here's the second part of building a no-code mobile application in Adalo. This time you'll see how to manipulate the spreadsheet data using UPDATE and DELETE requests via SheetDB's API. Link to part 1: ruclips.net/video/8rlVP06ITUA/видео.html 🌍 To test our product, visit SheetDB's website: sheetdb.io ✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io 🗞 For more content, ...
Create an HTML Table from your Spreadsheet's data
Просмотров 6 тыс.3 года назад
This video shows how you can generate an HTML Table snippet out of data from a Google Spreadsheet, by using the new feature that we implemented into SheetDB App. 🌍 To test our product, visit SheetDB's website: sheetdb.io ✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io 🗞 For more content, visit our blog: blog.sheetdb.io
Connect your Bubble-made web app to Google Sheets to fetch & manipulate data (NO CODE)
Просмотров 12 тыс.3 года назад
The second video of the NO CODE series. See how you can connect your Bubble web app to Google Sheets to fetch and manipulate data stored in a spreadsheet. 🌍 To test our product, visit SheetDB's website: sheetdb.io ✉️ With questions, opinions or suggestions, mail us at: support@sheetdb.io 🗞 For more content, visit our blog: blog.sheetdb.io
Create your mobile app (iOS/Android) with the Google Sheets data in Adalo + SheetDB (NO CODE)
Просмотров 50 тыс.3 года назад
Miko shows how to build a simple, yet fully functional mobile app, that reads and creates data in Google Sheets. All possible thanks to combined forces of SheetDB and a no-code application creator - Adalo. Correction: 5:10 - There should be the Album title column chosen for the Card List's Title, instead of the Artist, which belongs to the Subtitle. 🌍 To test our product, visit SheetDB's websit...
Generate HTML form that submits data from your WordPress site to Google Sheets
Просмотров 7 тыс.3 года назад
This video presents how you can submit data from your WordPress site, directly to a Google spreadsheet with the use of a new feature that we implemented into SheetDB, which is a form, generated by the app, which can be embedded into WordPress. 🌍 SheetDB website: sheetdb.io 🐦 Twitter: sheetdb_io ✉️ Mail us at support@sheetdb.io 🗞 SheetDB blog: blog.sheetdb.io
Build a Dialogflow chatbot with Google Spreadsheet integration
Просмотров 16 тыс.3 года назад
This time we are going to make a Dialogflow chatbot that will validate some details from the content of a Google Spreadsheet and store it to another tab using SheetDB. GitHub repo here: github.com/sheetdb/dialogflow-example/ Corrections: 2:40 - I made a typo in the intent's name which is later duplicated in the code, so everything works fine. 10:10 - That line of code should actually look like ...
Using the search feature in SheetDB API to filter results from Google Sheets
Просмотров 2,9 тыс.3 года назад
In this tutorial video I give you some hints on how to correctly use the search feature in SheetDB API and thus, to be able to filter your results, that are pulled from Google Sheets, any way you want to. You'll find this explained in writing at our blog: bit.ly/3uAmAlx 🌍 SheetDB website: sheetdb.io 😎 Link to our test spreadsheet if you want to play with it: docs.google.com/spreadsheets/d/1mrs...
How to send data to Google Sheets using an HTML form
Просмотров 29 тыс.3 года назад
This time I show you how you can easily gather data from visitors of your website using a form embedded in your site and store them in Google Spreadsheet with the aid of SheetDB app and some JavaScript. Here's the link to the promised CodePen: codepen.io/sheetdb/pen/VwPpJqx 🌍 SheetDB website: sheetdb.io 😎 Snippets to use: sheetdb.io/use-cases/submit-to-google-sheets-with-html-form ✉️ Mail us at...
How to connect Google Spreadsheet to WordPress. Part 2/2
Просмотров 4,4 тыс.3 года назад
The second part on how you can easily embed your Google Spreadsheet data into a WordPress site, by creating API with SheetDB App, so that the displayed content is always valid and coherent with your database. In this tutorial we show you some additional features of SheetDB that can be used in WordPress. 1️⃣ Part 1/2: ruclips.net/video/wwq4lqA1fxE/видео.html 🌍 SheetDB website: sheetdb.io 🗞 Sheet...
How to connect Google Spreadsheet to WordPress. Part 1/2
Просмотров 15 тыс.3 года назад
This video presents how you can easily embed your Google Spreadsheet data into a WordPress site, by creating API with SheetDB App, so that the displayed content is always valid and coherent with your database. Checkout the 2️⃣nd part: ruclips.net/video/lVedf7esFsU/видео.html 🌍 SheetDB website: sheetdb.io 🗞 SheetDB WordPress plugin's library: wordpress.org/plugins/sheetdb/ 🔎 Helpful article here...
sorry new to coding. how did you connect your google sheets to the script? i dont get it. thanks
Thanks a lot😁
hey do you know what to do if i want users to be able to delete any row they want
unable to upload image from csv file plz help
terrible instruction regarding postman.
Is it possible to filter using more than 1 column for example date and branch?
wow , Hats off to AI
Is it possible to print the artist details on a thermal printer?
how to create new table using api ? for example using php to create new table
Is Adalo FREE?!! what does in mean (200 Records) for a free membership? does it mean I can only enter 200 records to my Google sheets database only?
Amazing advice, I needed to make an app for my school assignment. Thanks you
Thank you very much. I tried, with success! But! The trial period at Adalo has ended. Do I understand correctly that in order to continue using your service, I need to make a purchase from Adalo up to the Team level? Thank you!
Hello. Could you tell me whether it is possible to periodically import Google Sheets or xlsx files from the cloud version of Excel, and have them saved in a folder? I would create the folder by logging into my Wordpress account with CyberDuck FTP, then enter that sheet's URL into another plugin that I want to use the spreadsheet with. Many thanks. Sarah
what if my google sheets / spreadsheet has formulas? will it carry over the formulas that is included in the file? if not, is there any way to?
Very nice and clear. Thanks for the tutorial
Thanks for this, very precize tutorial. Make more with database and mobile app! Cheers!
Thanks for your time!! ❤
It's not working ! I even copy the whole code from Github and paste (added my sheetdb link) still nothing in the excel.
กราบบบบบ ขอบคุณที่ช่วยชีวิตฉันในการเขียนโค้ดนะคะ
🙏🙏🙏🙏🙏
Thank you so much for the video! Everything works well, but there is an issue when dialogflow and Sheet DB api use the data in other languages. JSON uses some kind of encoding for other languages except English, so dialogflow does not recognize data
not working for me
the google sheet has to have all the sheets available_doctors, appointments, failed
How to upload a document in html form using sheetDB
What about validation ? If I want to eliminate duplicate entries...
Hi, I followed all the instruction and didnt work for me. Is there a difference from a year ago?
how do I ensure the data entry is timestamped? That way I can segment my data to know which days and time users use my service the most
how can I get other data like phone number, text field or selected option from select field
can we have multiple forms in single page ??
How to add image for the db so it can be shown in the app?
Hi - Do I have to call and save sheetdb on every page? Or is it possible to call sheetdb once and save it to a slot, for example at the top of the site, and then only call sheetdb-slot on all other pages? If so, is there a best practice as to where to put the first call? The home page, I'd guess... Thanks!
how to insert multipe row array looping data eloquent ?
With advancement of AI, we can now use ChatGPT: ruclips.net/video/TvwWxtkAdw8/видео.html
Is there ways to reload the page after form submit?
location.reload() - use this code in a success part
When we import from google sheet to create collection, there is no option for RELATIONSHIP. is there an option or do we need to update the primary and the foreign key for each collection to tie them up? THank you.
so this is only for accessing your own (the creator of a bubble app)'s google sheets? it doesnt allow users to access their sheets? seem pretty useless to me then.
When i go to Deploy, it say "error happened during cloud functions deployment". Why?
Many thanks to you for sharing key concepts to integrate the google sheet and I am grateful to you.
how i can do this whith JS and without postman?
Jesus, there is a UI option on how to do that in MS Excel - why should I suffer like this?
hello dear, thank you for sharing. I want to add the date as well, but cant. can you help me with it. the date is hidden, but should appear submition time on excel sheet.
is it possible to have different apis running for different users so as not see each other’s data?
Super helpful!
hahaha sheet db.. sounds like sh*t db xD love the idea tho
eccellente! I tried to convert this to a table booking app manager, still working on... basically a simple internal use app to manage the bookings of a restaurant accessible by the waiters and managers only. Kind of shared table online, managed by an app.
aaaa
bbbb
how can i send values to different sheets
Hi, that's video is great. It's possible make can two or multiple tabs sheet with your plugin?
Thankyou for your valuable time and info. Can i have answer of my one question?
How does this form know to send your data to the Leads spreadsheet?
First, when u create an account, you link a database to create an API for this spreadsheet. You don't even had to give editor allowance on the link to this work After you link you sheet on your dashboard, you will receive an API link, this link you add on inside you action=" " attribute on the form, together with the method="post" Using this link, the form will send the gathered data to your API :)
Oh, and to clarify, your first row, the one which have the column names, needs to have all the characters in lowercase (and without spaces too I think) Then you add the name="columnName" inside all your inputs, so that the SheetDB API knows which data to put inside each column Otherwise, if u don't follow these steps, you'll get the error "bad data format"
I think they changed the documentation to something like this name=Steve&age=22&casesensitive=true