Find Jobs
Hire Freelancers

Google Sheet to PHP Array Conversion

$30-250 USD

Complété
Publié il y a 5 mois

$30-250 USD

Payé lors de la livraison
I'm looking for a proficient PHP programmer who can extract textual data from my Google Sheet and transform it into an array(). Experience with Google Sheets API and data manipulation in PHP is essential for this task. The project involves: - Reading data: Your primary task would be to read my Google Sheets and extract the textual data. - Creating an array(): Please, only place your bid after making sure you fully grasp the project's requirements; if you have previously worked with PHP and Google Sheets API, this will be a plus. A week ago, my script to read Google Sheets in 5.6.4 died. A previous Freelancer delivered a PHP 8.2 project. But my old PHP 5.6 scripts running in 8.2 need a lot of updating (mysql based). So I would like to get back to reading with 5.6 while I spend the many weeks necessary to make new versions of my scripts for 8.2. I have learned all sorts of things about the compatibility of various future versions of PHP and Sheets. What I have come down to is this: I need to be able to read my Sheets in PHP 5.6. I had been for 10 years and now this is the second time that something has gone wrong and the access token was rejected. I know 5.6 is old, but there are serious differences between the next two versions of PHP which I also have access to: 7.4 and 8.0 (8.2). The differences are the way in which Arrays() are foreach(). I do have a working version of 8.2 to read sheets, but PHP 8.2 throws 100 errors when trying to foreach() the arrays. What I am looking for right now, is to be able to go back and read with PHP 5.6 so that I can maintain my back office statistics and accounting. Almost none of what I do in Sheets is used by my public-facing web pages. Just for my own internal use. Getting my 5.6 pages back working again will provide less stress for focusing on making 8.2 work. Fatal error: Uncaught exception 'Google_Service_Exception' with message '{ "error": "invalid_grant", "error_description": "Token has been expired or revoked." }' in /home/****/domains/******.com/public_html/Vishal/vendor/google/apiclient/src/Google/Http/[login to view URL] Stack trace: #0 The php code looks like this: (Vishal is or was a Freelancer member who set me up in 2019! I did find a current member with that name who works with Sheets, but he did not reply.) require_once (Vishal/includes/[login to view URL]'); $sheetId = "****"; setDifferentSheetFile( $sheetId ); $ThisSheet='****'; (the Sheet tab at the bottom) $ASERgs = getCellValues($ThisSheet); Simple Array() which I can foreach($ASERgs); //[2244] => Array //( // [4] => 2023-12-31 11:59:59 // [6] => so far // [8] => 7.89 // [16] => 53 //) [4], [6], [8], [18] are the columns in that Sheet. That is all Vishal's package did, and all that I need. Please advise.
N° de projet : 37620434

Concernant le projet

64 propositions
Projet à distance
Actif à il y a 5 mois

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Being deeply experienced and proficient in PHP, I assure you that I am the right freelancer for your project. I understand the unique challenges you are facing with PHP versions and the need to read your Google Sheets data effectively using PHP 5.6. I have hands-on experience working with different versions of PHP, including 5.6, 7.4, and 8.0 (8.2), and have encountered and resolved array-related issues similar to what you've described. My expertise extends to leveraging APIs, such as the Google Sheets API, as a part of my data manipulation work in PHP projects. Drawing from my skill set in PHP, I will ensure an efficient transformation of your Google Sheet's textual data into an array() format flawlessly aligned with your previous setup on PHP 5.6. My commitment to client satisfaction is unmatched and this project won't be an exception. As we collaborate, I will take the utmost care to ensure that the solution developed for you is effective; allowing you to maintain your back office statistics and accounting without any stress or disruption while you concurrently work on updating scripts for PHP 8.2. Let's get started on this incredibly important project together!
$30 USD en 2 jours
5,0 (4 commentaires)
1,2
1,2
64 freelances proposent en moyenne $127 USD pour ce travail
Avatar de l'utilisateur
Hello, my name is Abhishek. I have understood your job blueprint and this assignment fits within my operation of competence. I would cherish to come on board and start the job. I am available to begin forthwith. Relevant Skills and Experience - 14 years of experience in PHP - 5 star rated freelancer with over 390 completed projects - Got Preferred Freelancer award. - Fast communication and deliver on time
$100 USD en 3 jours
4,9 (411 commentaires)
7,8
7,8
Avatar de l'utilisateur
Google Sheet to PHP Array Conversion My name is Rana, and I'm contacting you from (TopIThuB). Hope you are doing well; we have checked your project description we are best for this project. Kindly send us a massage so that we will be able to send you customized proposal according to your project requirement. I look forward to hearing from you about the next steps and potentially working together in the future. Thank you, Regards; Topithub
$190 USD en 2 jours
5,0 (44 commentaires)
7,2
7,2
Avatar de l'utilisateur
Hi there, How r u? I have had a look at ur project i can handle it well as i have experience in PHP and Google Sheets. I have worked on similar projects before too. Please initiate the chat and discuss in detail. Waiting for ur kind response. Regards
$250 USD en 9 jours
5,0 (17 commentaires)
6,6
6,6
Avatar de l'utilisateur
Hi I checked your project description about - google sheet data to php array and mostly understands your project needs. I believe I can do this project in an efficient and professional manner. About Me: I have extensive experience in Web Development. Joomla, Magento, WordPress, ReactJS, AngularJS, NodeJS WooCommerce PHP Framework(Yii2), Laravel, Mobile app with Dart/Flutter for android/iOS app etc.
$250 USD en 7 jours
5,0 (65 commentaires)
6,8
6,8
Avatar de l'utilisateur
Hi Bradley T., I have carefully reviewed the requirements for your project and I am confident that I can deliver it with perfection. I have over 4 years of experience in PHP development and I am well-versed in working with Google Sheets API. If you have any questions or would like to discuss the project further, please feel free to connect with me in the chat. I am available and ready to assist you. Looking forward to working with you. Best regards, Christopher
$70 USD en 5 jours
5,0 (28 commentaires)
6,1
6,1
Avatar de l'utilisateur
Hello, I have carefully reviewed your project requirements and the challenges you are facing with the compatibility of PHP versions and the Google Sheets API. I understand the urgency to revert to PHP 5.6 for your current scripts while ensuring the smooth functioning of your back office statistics and accounting. I am a proficient PHP programmer with extensive experience in working with various PHP versions, including PHP 5.6, 7.4, and 8.2 and I have hands-on experience with the Google Sheets API, enabling me to efficiently extract textual data from your Google Sheet. I am adept at identifying and resolving issues similar to the one you described, such as token expiration errors. I will implement robust error-handling mechanisms to enhance the stability of your scripts. I am confident in my ability to address your specific needs and provide a reliable solution. If you agree with the proposed approach, please let me know, and we can initiate the next steps promptly. Thank you for considering my proposal. I look forward to the opportunity to assist you with this critical task. Best regards
$140 USD en 7 jours
5,0 (42 commentaires)
6,3
6,3
Avatar de l'utilisateur
With a dozen years of expertise in PHP, I am confident in my capability to resolve your Google Sheet predicament. I've not only worked with Google Sheets API extensively, but I've also handled numerous data manipulation projects using PHP, including your requirement of converting data to an array(). My previous clients can attest to my attention to detail and my ability to future-proof solutions. Coming to the specific issue you're facing with compatibility between PHP versions 5.6 and 8.2, fear not! I'm well-versed in managing different versions of PHP as well as the differences in processing arrays() with these versions. Drawing from this in-depth knowledge, I can successfully retrieve threadbare textual data for you from your Google Sheets while you take time to upgrade your PHP scripts. Given that internal usage often demands stability, dedicating myself to reinstating functionality for your PHP 5.6-powered back-office statistics and accounting won't be a problem. Additionally, my experience extends far beyond pure coding; my agile approach will optimize our workflow for efficiency throughout this project. My name does not start with Vishal, but I assure you that my commitment and delivery will rival any freelancer's quality work on this platform!
$250 USD en 7 jours
5,0 (16 commentaires)
6,1
6,1
Avatar de l'utilisateur
Hiya you will be required to read a google sheet file which contains textual data. - formatting data: once the data is read, you will need to parse through the data to determine it's structure and format it into appropriate php data types. - php array: once the data is read and formatted into an appropriate manner, you will then need to construct an php array() to contain the data. - google sheets api: prior to converting the data, you will be required to authenticate and connect to google sheets api.. If you have any questions, feel free to reach out. Thank you. Best regards, Giáp Văn Hưng
$125 USD en 7 jours
5,0 (99 commentaires)
5,9
5,9
Avatar de l'utilisateur
Dear Sir, as an 8-year web development expert, I assure you a swift completion of the Google Sheet to PHP Array Conversion project. Please initiate a chat to discuss the project details.
$80 USD en 1 jour
5,0 (87 commentaires)
5,8
5,8
Avatar de l'utilisateur
===== AVAILABLE FOR IMMEDIATE WORKING ======= Hi! I have gone through your job details and understood them. I can extract textual data from my Google Sheet and transform it into an array(). I'm working(part-time) as a full-stack developer for E-Vision Software Ltd, one of the oldest and most reputed IT firms in our city. === So, it’s a pretty simple task for me=== I've 8 years of experience in the field of FULL STACK WEB DEVELOPMENT with PHP, Python, Django, MySQL, JavaScript, JQuery, Vuejs, React, Codeigniter, Laravel, etc. Eagerly waiting for your response and am ready to start working instantly. === UNLIMITED REVISIONS UNTIL YOU ARE 100% SATISFIED === Regards
$98 USD en 1 jour
5,0 (33 commentaires)
5,7
5,7
Avatar de l'utilisateur
"Hi, I am an expert in PHP and Google sheet. Can create features based on your requirement Skills: NodeJs, Python, PHP Please message me for further discussion. Thanks!"
$75 USD en 3 jours
4,9 (67 commentaires)
5,6
5,6
Avatar de l'utilisateur
Hi, I'm interested in your requirements. I can manage your php version conflict and fix the sheet api I have good experience of web development with Google Sheets API - PHP We can discuss further on chat. Thanks!
$150 USD en 1 jour
5,0 (30 commentaires)
5,5
5,5
Avatar de l'utilisateur
Hello! I am a senior developer with over 10 years of industrial experience working with php and JavaScript. Regarding your project, while a temporary solution for PHP 5.6 might be feasible, strongly consider prioritizing the upgrade to a supported PHP version (8.2 or newer). This will ensure long-term compatibility, security, and access to modern features. Regarding the access code issue, try regenerate a new access token and update your code accordingly. I worked on a google sheets and docs api couple of years ago. If you can provide more details about your script, i can provide you with a better solution to resolve this issue. Regards, Ruchira J.
$150 USD en 7 jours
5,0 (23 commentaires)
5,6
5,6
Avatar de l'utilisateur
As a seasoned Full Stack Developer with over a decade of hands-on experience in PHP, I am confident in my ability to meet your project requirements. Having successfully built and scaled numerous web-based systems including inventories, ERPs, Account Management Systems, and Dashboards, I'm well-versed in efficiently transforming textual data like the one on your Google Sheets into PHP arrays. Even better, I have previous exposure to the Google Sheets API and strong proficiency in Core PHP which is a perfect fit for what you need. Throughout my career, I have also worked extensively with MySQL and have the capabilities to extract the specific column values you require from your Sheet. My devotion towards continuous professional growth has enabled me to familiarise myself with multiple PHP versions including 5.6 which you are specifically targeting. By embracing this version, I will ensure your back-office statistics and accounting can function seamlessly while you gradually adapt your new scripts for PHP 8.2.
$100 USD en 2 jours
5,0 (30 commentaires)
5,3
5,3
Avatar de l'utilisateur
As an experienced PHP developer with a strong foundation in both front-end and back-end development, I am confident in my ability to transform your Google Sheet's textual data into a PHP array(). I understand the constraints you're facing with PHP versions and the differences with arrays, which makes me uniquely qualified to handle this project. While many developers today have moved on to newer versions of PHP, my years of experience working with PHP 5.6 will be a great advantage in getting your old scripts running smoothly again. I appreciate the importance of maintaining your back-office statistics and accounting, which is why I am committed to delivering a solution that will work seamlessly with your existing setup. In addition to my broad technical skills, my meticulous attention-to-detail and problem-solving abilities will ensure that every aspect of the task is completed accurately and efficiently. I have worked extensively with databases, APIs, and server-side technologies - an indispensable requisite for extracting data from Google Sheets via API. By choosing me for this project, you not only gain an adept programmer but also an artist who understands the importance of visually appealing and highly functional work. With best regards, Arbaz S
$120 USD en 1 jour
5,0 (27 commentaires)
5,0
5,0
Avatar de l'utilisateur
Hey I see that Vishal code function works for you and you need the code with PHP 5.6 version so that you don,t have to face any compatibility issues. I got you covered as I have worked on PHP versions from PHP 3 to 8/latest and can work with almost all version and I also have experience of working with google sheet api as I have developed scrapper using python and use to store data and get data using api of google sheet. I am 100% certain I can develop you a perfect script that would allow to read textual data and turn it in to ARRAY of PHP 5.6 version with perfection. Please Open chat and we can discuss/ setup expectations. Best Regards Ali
$250 USD en 7 jours
5,0 (16 commentaires)
4,9
4,9
Avatar de l'utilisateur
I understand the importance of your need to revert back to PHP 5.6, and I'm confident in my ability to assist you with that. With over 5 years of experience in web development, I specialize not only in PHP, but also in data manipulation -- a skillset crucial for the task at hand. Moreover, my proficiency in handling Google Sheets and the Google Sheets API will surely come in handy as I extract and transform the textual data into the required format for you. I can create an array exactly as you specified:foreach($ASERgs), giving you a simplistic and functional output that will let carry on with your back office statistics and accounting smoothly. It is important for us to maintain timely communication, ensuring we are adapting the PHP code to your specific requirement for optimal functionality. My track record of punctual delivery and top-quality work solidifies my claim as one of the top freelancers in my field. The nature of this project aligns well with my skill set, making me an ideal fit for this job. So don't hesitate, let's get started on turning things around for you today!
$150 USD en 7 jours
5,0 (12 commentaires)
4,7
4,7
Avatar de l'utilisateur
Hey, I have an idea that might help you out, while not throwing away the baby with the bathwater. You keep your current code and we just add a function to generate the array. Now that function will call an instance of the new php82 script which will send back json and the function will decode that response into an array. Problem solved :) Thank you, Daniel
$140 USD en 7 jours
4,9 (30 commentaires)
5,0
5,0
Avatar de l'utilisateur
I am writing to express my interest in your project requiring a proficient PHP programmer to extract textual data from your Google Sheet and transform it into an array(). Having extensive experience with Google Sheets API and data manipulation in PHP, I am well-equipped to meet your project requirements. Reading Data: Utilize Google Sheets API to extract textual data accurately. Creating Array(): Transform data into a simple array() structure based on specified columns. Compatibility (PHP 5.6): Ensure code compatibility with PHP 5.6, resolving token expiration issues. Experience: Proficient in PHP 5.6, 7.4, and 8.0/8.2. Extensive Google Sheets API experience. Successful projects in similar tasks. Why Choose Me: Proven track record in PHP and API integrations. Strong problem-solving skills. Effective communication and collaboration. Ready to start promptly. Your satisfaction is my priority. Thank you for considering my proposal.
$140 USD en 7 jours
4,8 (15 commentaires)
5,0
5,0
Avatar de l'utilisateur
Hi, how are you? I go through the description and read it carefully, I know exactly what you are looking for. I have 5+ years’ experience in these skills PHP and Google Sheets. I have some question about this job, Please start chat, so we have detail discussion about your task. Thanks! Umair
$250 USD en 7 jours
5,0 (16 commentaires)
5,0
5,0

À propos du client

Drapeau de UNITED STATES
Las Vegas, United States
5,0
2
Méthode de paiement vérifiée
Membre depuis mars 9, 2014

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.