Improvement of Google Sheets CRM (Apps Script)

Hello,

Thank you for the detailed description, I will be happy to help with the implementation of the project. I am a Software Development Engineer with over 7 years of experience in creating various websites, SaaS solutions, complex web platforms, and MVPs for startups. In my portfolio, I have highlighted some of the projects I have developed.

My stack includes the following technologies and their frameworks: PHP (Yii2, Laravel, Symfony), HTML5, CSS3, JS (Vue.js, React.js), MySQL, PostgreSQL.

Show original

Translate

Hello.
I am ready to quickly and efficiently complete the task.
I have experience.
I suggest discussing the details in private messages.

Show original

Translate

Hello! I am ready to start working immediately after clarifying the details. I have extensive experience in developing and optimizing code in Google Sheets, organizing the interaction of spreadsheets with other Google services and third-party APIs, setting up triggers, and more.

Show original

Translate

Hello!

I am interested in your project and ready to complete it.

I have been working with Google Sheets for over 5 years and have significant experience in:
• developing custom solutions,
• creating templates,
• automating processes,
• integrating with third-party services,
… • developing complex formulas and scripts (Google Apps Script).

I am ready to discuss the details and find the best solution for your task. Let's communicate :)

Show original

Translate

Hello! I can do it!!!!!!!!!!!!!
Contact me!!!!!!!!!!!!!!!!!!!!!!!!!!

Show original

Translate

Hello!

I work with Google Sheets and Google Apps Script (V8), including integrations through Drive/Sheets API. I am ready to refine your CRM and correctly extract the main function into a separate file while preserving all connections, access rights, and stable trigger operation.

1. What I will do:
1.1. I will conduct an audit of existing functions — I will check the code structure, dependencies, trigger operation, and API calls.
1.2. I will optimize key scripts, and if necessary, extract repeating blocks into separate utilities.
1.3. I will extract the main function into a new Google Sheets file with correct data transfer (via `openById()` or API).
1.4. I will set up triggers (time-driven, onEdit, onFormSubmit) and logs (Logger / Stackdriver).
… 1.5. I will add protection for critical ranges and check user permissions.

2. Clarifications:
2.1. Is the main function the processing of applications, updating statuses, or linking between tables?
2.2. Does the CRM operate independently or integrate with other services (Gmail, Forms, API)?
2.3. Will it be possible to provide temporary access to Apps Script, or are we working in a format where "you share your screen — I give instructions"?

3. Conditions:
— Rate: $20/hour.
— Estimate: 6–8 hours (within 1 calendar day).
— Work through escrow, with a short report and result verification.

I am ready to connect today to understand the current code and safely extract the main logic into a separate file without losing functionality.

Show original

Translate

Good afternoon. I would be happy to help. But I would like to receive a more detailed description of the task.

Show original

Translate