Google Forms Survey + Processing in Google Sheets (online)
Volunteer project on psychometrics for war veterans. A specialist in Excel/Google Sheets is needed (Category: *Data Entry / Surveys / Google Workspace*
- Subcategory: *Online Surveys, Psychological Questionnaires, Data Processing* )
for:
- Creating Google Forms: adapt the 5PFQ questionnaire (75 questions, Likert scale), with branching logic, conditional visibility of questions, timing, and protection against IP/email duplication. (already created, but needs to be agreed upon with the performer)
- Data processing in Google Sheets: automatic import of responses, calculation of scores across 5 scales (openness, conscientiousness, etc.), normalization, graphs (radar charts, histograms), export to CSV/Excel. Additionally: filters, pivot tables, Apps Script scripts for automation (e.g., PDF reports).
REQUIREMENTS
- Experience with Google Forms/Sheets (Apps Script is a plus).
- Understanding of psychological tests (e.g., 5PFQ or Big Five) — is a plus.
- Not urgent: launch upon readiness and agreement on the terms of reference. 3-5 days.
- Budget: 100-400 USD (depending on complexity + 10% bonus for smoothness).
Please send examples of work (links to Forms/Sheets), timelines, and your proposed price.
Volunteer project on the psychometrics of war veterans. A specialist in Excel/Google Sheets is needed (Category: *Data Entry / Surveys / Google Workspace*
- Subcategory: *Online Surveys, Psychological Questionnaires, Data Processing* )
for:
- Creating Google Forms: adapt 15 psychological questionnaires - with a total number of questions not exceeding 600.
For example: 5PFQ (75 questions, Likert scale), with branching logic, conditional visibility of questions, timing, and protection against IP/email duplication. (already created, but needs to be agreed upon with the performer)
- Data processing in Google Sheets: automatic import of responses, score calculation, providing psychological characteristics based on them, normalization, graphs (radar charts, histograms), export to CSV/Excel. Additionally: filters, pivot tables, Apps Script scripts for automation (for example, PDF reports for a specific veteran or their group {up to 300 people} sent to email with duplication in Google Sheets).
REQUIREMENTS
- Experience with Google Forms/Sheets (Apps Script is a plus).
- Understanding of psychological tests (e.g. 5PFQ or Minimult) — is a plus.
- Not urgent: launch upon readiness and agreement of the terms of reference. 5-10 days.
- Participation in the development of the terms of reference.
- Budget: 100-400 USD (depending on complexity + 10% bonus for smoothness).
Send examples of work (links to Forms/Sheets), timelines, and your proposed price.
APOLOGIES: Please forgive any cardinal inaccuracies in the first version of the project.
Волонтерский проект з психометрії ветеранів війни. Потрібен спеціаліст з Excel/Google Sheets ( Категорія: *Data Entry / Surveys / Google Workspace*
- Підкатегорія: *Online Surveys, Psychological Questionnaires, Data Processing* )
для:
- Створення Google Forms: адаптувати психологічні опитувальники 15 шт. - з загальною кількістю запитань не більше 600.
Наприклад: 5PFQ (75 запитань, шкала Likert), з логікою розгалуження, умовною видимістю запитань, таймінгом та захистом від дублювання IP/пошти. (вже створено, але треба узгодити з виконавцем)
- Обробка даних у Google Sheets: автоматичний імпорт відповідей, розрахунок балів, надання по ним психологічних характеристик, нормування, графіки (радарні діаграми, гістограми), експорт у CSV/Excel. Додатково: фільтри, pivot-таблиці, скрипти Apps Script для автоматизації (наприклад, звіти PDF по конкретному ветерану або по їх групі { до 300 людей} на пошту з дублюванням в Google Sheets).
ВИМОГИ
- Досвід з Google Forms/Sheets (Apps Script вітається).
- Розуміння психологічних тестів (напр. 5PFQ або Minimult) — вітається.
- Не терміново: запуск за готовністю і узгодженням ТЗ. 5-10 днів.
- Участь в розробці ТЗ.
- Бюджет: 100-400 USD (залежно від складності + 10% бонус за безпроблемність).
Надішліть приклади робіт (посилання на Forms/Sheets), терміни та Вашу пропоновану ціну.
ВИБАЧЕННЯ: Даруйте за кардінальні неточності в першому варіанті проекту.
Applications 2
-
3619 65 0 Hello! 👋
I am ready to join the project and help with the implementation.
I work with Google Forms and Google Sheets.
A test example of your project:
https://docs.google.com/forms/d/161rUAzJiC5QBqRn37LDDO9JssFcJpEvdON7OBnvhWkU/edit
Updates:
… https://docs.google.com/forms/d/e/1FAIpQLSdq3iokuliLi64towIh2uta1bLviezPovxfr4M6wB5_m61EDQ/viewform
https://docs.google.com/forms/d/e/1FAIpQLScHyPhrYiTP5bwy3--pFsYJTEi6v4QzyPae4x1a9ScZuQbLZw/viewform
The project is important and socially significant — I would be happy to join.
I am ready to discuss the details, review the current form, and suggest optimal solutions.
-
115 1 0 Hello! My name is Danilo, I work as a Data Analyst and have 3.5 years of experience working with large datasets and process automation.
Why I am confident in the result:**
Technical part: I have experience in developing complex systems in Google Sheets using Apps Script (specifically integrations via API). Implementing automatic PDF report generation based on form responses is a familiar task for me.
Test mathematics: I understand the logic of 5-factor questionnaires (Big Five). I will set up correct score normalization and build radar charts (spider graphs) for visualizing the veteran's profile.
Quality: As an analyst, I am used to regular reporting and clear algorithms, so I guarantee the absence of errors in the calculation formulas.
…
Proposal:
Price: 250 – 300 USD (depending on the final volume of report automation).
Deadline: 4-5 days (considering thorough testing of branching logic in Forms).
I am ready to discuss the terms of reference and am genuinely interested in helping your initiative.
-
718 5 0 Hello, I have a very large experience in working with Google Sheets, using many formulas and Apps Script for data analysis. I propose to implement this project in the format of a quiz (survey) + data analysis in Google Sheets (using formulas, scripts, data visualization). Also, it will generate PDF reports, perform data export. Please provide a more precise technical specification for building the logic. It will be interesting to work and contribute to a volunteer project for veterans, as I am currently an active serviceman. I will be happy to collaborate.
-
10321 128 0 Good day
I have extensive experience with App Script and Google Sheets
I can implement it, but I need clarification on what kind of branching plan is intended to be used.
-
3012 73 4 2 Good day! I have a very large experience in working with Excel/Google Sheets (Apps Script) and Google Forms!!! Therefore, I can perform the task you set very qualitatively!!! All corrections (if there are any) will be done absolutely free of charge!! Feel free to contact me!! Here are links to completed similar projects:
https://freelancehunt.com/project/nalashtuvati-gugl-formi-gugl-tablitsi/1540589.html
https://freelancehunt.com/project/sozdat-anketu-cherez-google-form-25-30/1564915.html
https://freelancehunt.com/project/publikator-postiv-facebook-tablits/1545223.html
https://freelancehunt.com/project/rozrobiti-skriznu-analitiku-nayavnih-gugl/1529164.html
https://freelancehunt.com/project/vidformatuvati-ta-zrobiti-shablon-google-tablitsi/1483517.html
-
1322 13 1 Hello! My main workplace is a large international charitable foundation, where I hold the position of database manager and I am specifically involved in the development and maintenance of databases, surveys, and data processing. I have many years of experience working in this field and understand all the nuances of Google Forms compared to alternatives. I understand the requirements of laws, GDPR, and others.
I work with formulas, scripts, and, if necessary, third-party automation.
I am ready to study your technical specifications in detail and, if needed, help compile the necessary parts.
-
2327 61 0 Hello. The technical specification is completely clear. The task is not complicated, the only thing is to agree with you on which specific charts/dashboards you expect. I have extensive experience working with databases. In fact, based on the questionnaire (live), we need to create a visual/tabular analysis of the responses.
-
1449 24 3 Hello, I am ready to quickly and efficiently complete the task. I have experience in performing similar tasks. I suggest discussing the details in private messages.
Current freelance projects in the category Data Processing
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
90 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 9 hours 25 minutes back ∙ 13 proposals |
Creation of an Excel file for uploading products to the website.It is necessary to create an Excel file and fill it with the data we provide, making the file such that it can be uploaded to the website. Similar to Rozetka, WordPress, Prom, and so on. About 100 items. Data Processing, Technical Documentation ∙ 3 days 5 hours back ∙ 35 proposals |
Sendpulse specialistGood day. I need help with setting up SendPulse, specifically CRM + Automation. We will discuss the details in private. The project looks approximately like this: 1. Set up a CRM funnel for selling digital products/services. - 6 products. 2. Set up automation after successful… Online Stores & E-commerce, Data Processing ∙ 3 days 6 hours back ∙ 6 proposals |
Setting up and optimizing the lawyer's existing social media accountsFor the startup (without launching advertising in the first stage) it is necessary: - to set up a Facebook page, Instagram, a lawyer's Telegram, a lawyer's association page, Meta Business Suite, a Telegram channel, and a consultation route Facebook → Instagram Telegram →… Data Processing, Customer Support ∙ 4 days 2 hours back ∙ 6 proposals |
Assistance with AI, personal social media, and operational tasks for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 5 days back ∙ 8 proposals |