Easy Cash $$$ for google sheets expert, gscript developers and Arduino developers

  • Status: Closed
  • Prize: €100
  • Entries Received: 9
  • Winner: astaroht

Contest Brief

Automate google sheets data log from an Node MCU ESP 32-S board and connect several google sheets together to win.

I need to connect several excel sheets with code in gscript.
See attached image for examples and the data format for google sheet C
I am looking a developer to join my team.

To archive the goal follow the following instructions:

Step 1: Write code for the Node MCU ESP32-S Board to read analogue data and log it to an google sheet, call this google sheet A
The board will use its wifi functionality to send and log the data to a google sheet every 5 minutes...

Step 2: Fetch the user input data from a different google sheet, call this google sheet B and log the data in google sheet C

Step 3: Fetch the analogue data for the Current electric value from google sheet A and log it to google sheet C

Step 3: Calculate the remaining values in your code and log the results in google sheet C

Bonus points if you have your own ESP32 - S board and have tested the code for the ESP32-S
Bonus Points if you can show me everything working


Contest will end once I have a good result

Recommended Skills

Employer Feedback

“Thank you for you help”

Profile image IcoNNZ, Ireland.

Top entries from this contest

View More Entries

Public Clarification Board

  • astaroht
    astaroht
    • 3 years ago

    Hey, I've submitted an entry (with a video link as well). Do check and let me know.

    • 3 years ago
    1. IcoNNZ
      Contest Holder
      • 3 years ago

      Excellent entry... It shows that you understand what I am looking for... I like that you created a video to show your work... I think one of your formula is not accurate... Also I like how you generated your own values to test your work...

      • 3 years ago
  • Pjangid06
    Pjangid06
    • 3 years ago

    #include
    #include "HTTPSRedirect.h"
    #include "DebugMacros.h"
    #include

    #define DHTPIN D4 // what digital pin we're connected to
    #define DHTTYPE DHT11 // select dht type as DHT 11 or DHT22
    DHT dht(DHTPIN, DHTTYPE);

    float h;
    float t;
    String sheetHumid = "";
    String sheetTemp = "";

    const char* ssid = "hayatit"; //replace with our wifi ssid
    const char* password = "hayatitjangid"; //replace with your wifi password

    const char* host = "script.google.com";
    const char *GScriptId = "AKfycbxy9wAZKoPIpPq5AvqYTFFn5kkqK_-avacf2NU_w7ycoEtlkuNt"; // Replace with your own google script id
    const int httpsPort = 443; //the https port is same

    // echo | openssl s_client -connect script.google.com:443 |& openssl x509 -fingerprint -noout
    const char* fingerprint = "";

    • 3 years ago
    1. IcoNNZ
      Contest Holder
      • 3 years ago

      You solution is incomplete...

      • 3 years ago
  • Shaun4321
    Shaun4321
    • 3 years ago

    How do you intend to transfer the data from the Board to Google sheets, wifi/Bluetooth? Are you considering using the IFTTT webhooks to connect the device to Google sheets? Do you have any examples of the logged data you expect to see from Google sheets A and B?

    • 3 years ago
    1. IcoNNZ
      Contest Holder
      • 3 years ago

      Yes you are right those are in mV... You are on the right track the 0.457V is measured from a sensor that measures 20A/1V, that means the, the 0.457V can be converted into 9.14 Amps... from here the rest easy easy to work out... Yes you are right the is a lot of data missing... That was intentional

      • 3 years ago
    2. Shaun4321
      Shaun4321
      • 3 years ago

      Cool, I'm with you on the missing data. I don't have a Node MCU ESP32-S Board but googled it plenty to have an idea what is needed. Some of the data doesn;t tie back, but i think the main functionality of moving data between sheets i have. TH euploading from th board via wifi, i'm not 100% fully across, but rest assured, if you can get the data into a google sheet then I can move it to another google sheet.

      • 3 years ago
  • StrongDecs
    StrongDecs
    • 3 years ago

    Hello, Increase price please. Thanks

    • 3 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!