element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • About Us
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Arduino
  • Products
  • More
Arduino
Arduino Forum Data Logging with video feed and Logging to Google Sheet
  • Blog
  • Forum
  • Documents
  • Quiz
  • Events
  • Polls
  • Files
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Arduino to participate - click to join for free!
Actions
  • Share
  • More
  • Cancel
Forum Thread Details
  • Replies 6 replies
  • Subscribers 386 subscribers
  • Views 1522 views
  • Users 0 members are here
  • esp32
Related

Data Logging with video feed and Logging to Google Sheet

ab9nq
ab9nq over 2 years ago

“CameraRainGauge” Project

Project is a data logger of weather observations served to two websites and logged to Google Sheet continuously; month by month. Google Sheet Script was inspired by this article:

ESP32 Data Logging to Google Sheets with Google Scripts

Project would have been impossible for me without the help of people from community; arduino.cc Forum, Adafruit.com Forum, ESP8266 Forum, Github.com, Random Nerd Tutorials Forum. Project started back in the Fall of 2013; with gifted "Arduino Uno." Thank you to all the people that have helped with the project!

Project served from ESP32

Project served from Domain, Hosting Provider

"CameraRainGauge” project was developed to provide a data logger accessible over the Internet, provide file transfer protocol (FTP), over-the-air (OTA) firmware updates, two web sites, WebRTC video feed, and uploading data to Google Sheets!

WebRTC video is served from Raspberry Pi running Wyze-Brige Docker container.  No special firmware is required for the Wyse Cam v3 camera.   Camera view of wetland pond

Live Google Sheet data logging

Gist of Google Sheet Script; plus Arduino code for sending data

“AsyncWebServer” handles "GET" requests from the Internet for processing of web pages.

William

  • Sign in to reply
  • Cancel

Top Replies

  • ab9nq
    ab9nq over 2 years ago +1
    Review of CameraRainGauge project "I recently came across the CameraRainGauge project hosted on GitHub, and I must say it is quite impressive. The project, developed to provide data logging accessible…
  • ab9nq
    ab9nq over 2 years ago

    Moderator:  Please delete this discussion.  Can not edit my mistakes with links.

    Discussion has been edited; please cancel request to delete.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • shabaz
    shabaz over 2 years ago in reply to ab9nq

    Hi,

    For when/if you re-do it, there's an editor tool for adding links. You've used Markdown-style links, but this system does not support that.

    See the screenshot below:

    image

    Secondly, the post doesn't make sense; the sentences are incomplete. For instance, see this sentence:

    Uploading data to Google Sheet by the month for a year.

    Shouldn't that sentence start with "I uploaded data..." or "It is possible to upload data.."? I wouldn't normally mention it, but in the case of the post above, nearly all the sentences are incomplete, and it isn't easy to follow. Nearly all the sentences are missing something. Here's another example:

    Project would have been impossible for me without the help of people from community.

    That sentence should perhaps start as "The project.." or "This project..".

    A free-to-use tool such as Grammarly can be installed inside the web browser to assist with sentence spelling and grammar automatically.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • ab9nq
    ab9nq over 2 years ago in reply to shabaz

    Will correct.  Found the tool after commiting the post.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • cstanton
    cstanton over 2 years ago in reply to ab9nq

    You should have the edit ability under the 'more' link, let me know if you do not.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • ab9nq
    ab9nq over 2 years ago in reply to cstanton

    Discussion start has been edited.  Thank you cstanton.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • ab9nq
    ab9nq over 2 years ago

    Review of CameraRainGauge project

    "I recently came across the CameraRainGauge project hosted on GitHub, and I must say it is quite
    impressive. The project, developed to provide data logging accessible over the Internet, offers a
    plethora of features that make it a valuable tool for environmental data enthusiasts." --ChatGPT

    • Cancel
    • Vote Up +1 Vote Down
    • Sign in to reply
    • Cancel
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube