website table from google sheets table
$30-250 USD
Bezahlt bei Lieferung
We are seeking proposals for the development of a single webpage with a single table containing data from a Google Sheet. This document outlines the project requirements.
Project Overview:
We have an existing Google Sheet named "nets" that contains a table with 4 columns and 17 rows. The values in this table are changed by an operator every 5 seconds. Our goal is to build a webpage that displays this table data to approximately 500 users and visitors (maximun). The webpage should update the table every 5 seconds to reflect the changes made by the operator. Additionally, we require a caching solution to minimize requests to the Google Sheets API.
The proposed solution should include the following components:
a. Frontend Development:
Development of a responsive webpage using HTML, CSS, and JavaScript.
Design and implementation of a table layout that matches the structure of the Google Sheet table.
Integration of JavaScript code to fetch and display the data from the Google Sheet table.
Implementation of a client-side auto-refresh mechanism to update the table every 5 seconds.
b. Backend Integration:
Utilization of the Google Sheets API to access and retrieve data from the "nets" Google Sheet.
Development of a server-side script to interact with the Google Sheets API and fetch the updated data.
Implementation of a caching solution to minimize requests to the Google Sheets API.
Configuring an appropriate cache expiry time to balance data freshness and API usage.
c. Real-Time Updates:
Implementation of a notification mechanism to achieve real-time updates when the Google Sheet data changes.
Periodic checking for changes in the Google Sheet data using the Google Sheets API.
Sending notifications to the connected clients when a change is detected.
Client-side JavaScript code to initiate a data refresh and update the table in real-time.
Performance and Scalability:
The solution should consider performance and scalability aspects, including:
Optimization techniques to ensure efficient data retrieval and rendering on the webpage.
Implementation of a caching mechanism to minimize requests and reduce server load.
Load testing to verify the solution's ability to handle the expected traffic from 500 users and visitors.
Projekt-ID: #36721691
Über das Projekt
67 Freelancer bieten im Durchschnitt $191 für diesen Job
Hiii, How are you?? I have checked job description and understood complete scope of the work and you want someone who can design single webpage with a single table containing data from a Google Sheet and will follow Mehr
Hello, Hope you are doing great, As per your work requirements which you mentioned in project description i can design and develop a fully professional web page, i have a 8+ year experience for web designing and devel Mehr
HI, I have read your details and i am interested. We have build similar scripts in the past using google spreadsheets and sheets. just ping me if you are interested in working with you
Hi There, I can make website table from google sheets table .I have read your job description and assure you that I am a perfect fit for the job.I have over 7+ years of experience in PHP , Laravel, CodeIgniter, Angula Mehr
Hello, Hope you're doing good ! I have read your job description regarding "Website table from google sheets table" and assure you that I am a perfect fit for the job. I am a senior Web Programmer, having 10+ years of Mehr
Hi there! My name is Pooja and I'm a professional with 10+ years of experience in web design and development. I understand that you are looking for proposals for the development of a single webpage with a single table Mehr
Hello! My name is Navjot and I am an experienced freelancer with 7+ years of experience in web design and development. I understand that you are seeking proposals for the development of a single webpage with a single t Mehr
When you say "Design and implementation of a table layout that matches the structure of the Google Sheet table," you mean to say that the appearance of the table in your website should be identical to that Google Sheet Mehr
Hello, my name is Anshu and I'm part of the Zeta Group, a professional IT company with more than 9+ years of experience in Information Technology. We understand you are seeking proposals for the development of a single Mehr
Hello Nuno L., I appreciate the opportunity to review the project details for "website table from google sheets table" and would like to seek some clarifications. As a seasoned professional in website design and devel Mehr
Hello! My name is Muhammad and I am an experienced web developer. I have worked on countless web development projects and have a wealth of skills that can be used to create your website including website design, PHP de Mehr
Hello Nuno L., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP Lets connect in chat so that We d Mehr
Hello, I'm Adnan, and I'm excited to hear that you are looking for proposals for the development of a single webpage with a single table containing data from a Google Sheet. I believe that I am the perfect person to he Mehr
