website table from google sheets table
$30-250 USD
Dibayar semasa penghantaran
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.
ID Projek: #36721691
Tentang projek
67 pekerja bebas membida secara purata $191 untuk pekerjaan ini
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
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 Lagi
