search

Dprof-in-tech / peer-on-strk

https://peer-on-strk.vercel.app
1 stars 9 forks source link

INTEGRATE WAITLIST TO GOOGLE SHEETS #4

Open Dprof-in-tech opened 3 days ago

Dprof-in-tech commented 3 days ago

Integrate the peer protocol waitlist which can be found at https://peer-on-strk.vercel.app/Waitlist to a google sheet to store the data on submission.

New Details on this Issue: The framework in use for this project is Nextjs so your solutions should be tailored towards levergaing what Nextjs can do for the form submissions and integration of google sheets.

if you have any questions, do not hesitate to ping me or ask a question in our telegram group.

CollinsC1O commented 3 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

Hello! I'm a front-end and a blockchain developer. I will love to work on this issue please

How I plan on tackling this issue

mexes20 commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

Hello can I be assigned to work on this as a first time contributor to the project.

I am a developer with over 4 years of experience.

ETA: One day

josephchimebuka commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I am Joseph I am a frontend developer and blockchain developer and I am also an active contributor here on only dust here is my profile https://app.onlydust.com/u/josephchimebuka. This is my first time to contribute to this repo ill appreciate the opportunity to contribute. this is a couple of frontend and blockchain projects i have built https://metacrypt.vercel.app/ https://mattedsgn.com/

How I plan on tackling this issue

I will Integrate the peer protocol waitlist to store data on submission

Samuel1-ona commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged Hello , i am samuel , i am a blockchain developer and a security researcher

How I plan on tackling this issue

  1. I will inspect the waitlist form to see if it is structured and clean
  2. Go to Google Sheets and create a new spreadsheet to store the submitted data and Name the columns according to the fields in the waitlist that is according to the individual and business feilds.
  3. I will write a script that will store the waitlist

This is my first application to onlydust, if i am assigned i will execute very fast.

Thank you.

0xdevcollins commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

Hi, I'm Collins a frontend and blockchain developer, and an active contributor on OnlyDust. You can check out my profile here: https://app.onlydust.com/u/0xdevcollins. This is my first time contributing to this repository, and I’m excited about the opportunity to contribute. Looking forward to collaborating!

How I plan on tackling this issue

I will integrate the waitlist to a google sheet

juandiegocv27 commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I’m a software engineer with experience in both front-end and blockchain development. Here’s how my background can be relevant for this task:

How I plan on tackling this issue

  1. Review the current structure:
    I will start by reviewing the current waitlist form at the provided URL to understand how it’s structured and how the data is collected.

  2. Set up Google Sheet:
    Next, I will create a Google Sheet with columns matching the form fields for smooth data integration.

  3. Google Sheets API setup:
    I’ll set up the Google Sheets API and create a service account to allow data submission from the form.

  4. Integration:
    Using TypeScript, I’ll integrate the Google Sheets API with the existing form, ensuring that the form data is sent directly to the Google Sheet upon submission.

  5. Testing and debugging:
    Finally, I will test the entire process by submitting test entries and debugging any issues that arise to ensure everything works correctly.

Jayse007 commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I would like to take this job to be delivered by 1st of November. I have experience working with files in Python. I can manipulate googlesheets with the aid of a python module called gsheet. So updating the data received will be no problem with python.

How I plan on tackling this issue

I would make use of gsheet module in python to add the entries from the frontend form into the specified googlesheet. Once the data is submitted by the user and my python script receives it, it will be arranged according to your specifications - the columns, capitaliation and so on.

martinvibes commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

hello @ i'm an experienced frontend developer and a blockchain developer i would love to work on this issue Pleasee kindly assign :)

Benjtalkshow commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I am a Full Stack Developer specializing in Next.js, TypeScript, Node.js, Cairo and Rust . With over 31 contributions across projects in the OnlyDust ecosystem, I’ve developed strong proficiency in delivering high-quality solutions and resolving complex issues within tight deadlines. My experience spans frontend, backend, smart contracts, and the optimization and maintenance of scalable codebases.

How I plan on tackling this issue

To integrate the peer protocol waitlist from the provided URL into Google Sheets, I will set up a system that captures user submissions from the waitlist and automatically stores the data in a designated Google Sheet. This will involve creating a form that collects necessary information from users and connecting it to the Google Sheets API to ensure seamless data transfer.

Once the integration is complete, all submissions from the waitlist will populate the Google Sheet in real-time, allowing for easy tracking and management of the waitlist data. If there are any questions or if clarification is needed during the process, I will reach out directly for assistance.

ShantelPeters commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I have a strong background in web development and API integration, with experience in JavaScript and Google Apps Script. My skills include creating seamless connections between web applications and backend systems, as well as working with Google Sheets to manage and analyze data effectively. This experience allows me to efficiently handle data submissions and ensure that the integration is robust and reliable.

How I plan on tackling this issue

To integrate the peer protocol waitlist with Google Sheets, I will follow these steps:

Analyze the API: First, I will review the waitlist API documentation at the provided link to understand the required data structure, endpoints, and methods for submitting entries.

Set Up Google Sheets: I will create a Google Sheet to store the waitlist data, ensuring the columns correspond to the data fields from the API (e.g., name, email, submission timestamp).

Use Google Apps Script: I will write a Google Apps Script that triggers on form submission or through a custom endpoint. This script will:

Capture the data submitted to the waitlist API. Parse the response and extract relevant data. Append the extracted data to the designated Google Sheet. Testing and Validation: I will thoroughly test the integration to ensure that data is correctly submitted and stored in the Google Sheet. This will include checking for any potential errors or discrepancies.

Documentation and Maintenance: Finally, I will document the integration process, including any necessary credentials, scripts, and instructions for future reference. I will also set up monitoring to ensure the integration remains functional and address any issues that may arise.

Throughout the process, I will maintain communication and be available for any questions or feedback.

aniruddhaaps commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I am a python dev . A new-comer here, willing and ready to contribute to solve the issue.

emarc99 commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

I have a strong background (1 year) in blockchain development, with expertise in writing Solidity, and fundamental knowledge of Cairo, and zero-knowledge proofs (zk). I have built dApps on Ethereum (and Scroll) using token standards; UniSwapv2 clone, Multi wallet, Gated NFT Event Management system, Crowdfunding. I also do FE/wallet integration using Reown, web3js and ethersjs. As well as subgraph for efficient indexing.

This issue will enable me to contribute to an open-source project for the first time, learn and build.

How I plan on tackling this issue

  1. Create and set up a new blank Spreadsheet
  2. Access Appscript from the Spreadsheet, in a new web-based editor
  3. Add a script and deploy the app
  4. Copy and save deployment ID and Web App URL
  5. Set up a Trigger for Valid Submission from Waitlist website (https://peer-on-strk.vercel.app/Waitlist)
  6. Implement into Waitlist form, pass deployed app ID to the base URL Issue solved.
mimisavage commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

Hi, I’m Mimi Sav, a frontend and blockchain developer. This is my first time contributing to this repository, and I'm excited about the opportunity to collaborate.

How I plan on tackling this issue

To integrate the peer protocol waitlist into a Google Sheet for data storage on submission, I would start by reviewing the API documentation at the provided URL to understand how to submit data and the required fields. Then, I would create a new Google Sheet or use an existing one, ensuring that it has the necessary columns, such as name, email, and date of submission, to match the data from the waitlist.

Next, I would write a Google Apps Script to handle incoming data submissions. This script would listen for requests and append the submitted data to the Google Sheet. After that, I would deploy the script as a web app, configuring its permissions to allow access so it can accept POST requests.

To connect the waitlist form to the Google Apps Script, I would modify the submission process to send the data to the web app's URL instead of its current endpoint. Finally, I would test the integration thoroughly to ensure that data is submitted correctly from the waitlist form and stored in the Google Sheet as expected.

suhas-sensei commented 2 days ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged

would love to work on this

blessingbytes commented 2 days ago

I'd love to work on this!

ikezuby2012 commented 1 day ago

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged Hi, I’m zuby, a fullstack and blockchain developer. i have a strong background in web development especially building API with expertise in writing nodejs and asp.net, This is my first time contributing to this repository, and I'm excited about the opportunity to collaborate.

How I plan on tackling this issue

Build an API: i will use a framework like Node.js or .NET to build a simple REST API that accept the required credentials and placeholders (e.g., customer data) in the JSON payload. Google Sheets and Drive Setup: then Use the Google Sheets API to create a new Google Sheet in the assigned Google Drive and leverage the Drive API to manage file creation and permissions for access. App Script for CSV Creation: Write a Google Apps Script to automate the creation of a CSV file from the Google Sheet. This script will Pull data from the sheet, Replace placeholders in the template, Convert the final data into CSV format, After placeholders are replaced, the script will Generate the CSV file and save it in the Google Drive folder or provide a downloadable link for the API response.

ETA: Two days

jaiminRaiyani commented 1 day ago

May I take this issue on?

Jemiiah commented 1 day ago

@Ugo-X and @Dprof-in-tech can I take this up ? ETA : 48hours

DotworldX commented 1 day ago

May I take this issue on?

reetbatra commented 1 day ago

I'd love to work on this!

shubha-me commented 1 day ago

Could I be assigned to this?

kfastov commented 1 day ago

I'm a Full Stack Web3 Developer and currently developing my personal project using Next.js, so I already have experience with it. I would quickly learn the Google API and implement the hooks that will update the desired worksheet based on new submissions. May I be assigned to this?