Following the abrupt transition away from AppScript, I officially started migrating the project to PHP today. I focused on transferring the user management module, which serves as the foundation of our entire system.
I began by restructuring the logic of the existing scripts, converting AppScript functions into their PHP counterparts. Authentication, account creation, user role assignments, and session handling were all rewritten using PHP’s native features and libraries.
One of the key challenges was figuring out how to communicate efficiently with Google Sheets from PHP. I explored the use of Google Sheets API and successfully set up credentials and authorized data access, ensuring we could still perform read/write operations to our database.
Despite the unfamiliarity of working entirely in PHP for this project, I found the process engaging and more flexible than AppScript. It gave us greater freedom to handle logic, optimize performance, and secure user sessions.
By the end of the day, the basic components of user management were up and running. It was a solid start toward rebuilding the entire system from the ground up.