Budget: 4998 UAH Deadline: 30 days
To implement your request and ensure quality results without duplicates, I propose the following plan for engaging and technically filtering respondents.
Channels of engagement and volumes
Sources: Profiled Telegram channels and Viber chats of drivers (taxi Uklon/Bolt, professional communities of long-haul truckers, local groups "Mutual Aid on the Roads").
Targeting: Direct communication in chats with an emphasis on a short survey time (up to 5 minutes) and clear rewards.
Expected volume: 50–150 respondents within 3–5 working days.
Technical validation (The "Me4Hik" Way)
Since Google Forms have limited fraud protection measures, I can implement Apps Script directly in your response sheet. This will allow for automated checks:
Auto-detect duplicates: The script will instantly highlight or move to archive entries with the same phone numbers or emails.
Quality control: Automatic verification of all mandatory fields before final acceptance.
// cursor by Me4Hik START - Automated duplicate check for Google Sheets
function validateEntries() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = sheet.getDataRange().getValues();
const uniqueKeys = new Set();
for (let i = 1; i < data.length; i++) {
let key = data[i][1]; // Assuming phone is in the second column
if (uniqueKeys.has(key)) {
sheet.getRange(i + 1, 1, 1, sheet.getLastColumn()).setBackground('#f4cccc'); // Highlights the duplicate
} else {
uniqueKeys.add(key);
}
}
}
// cursor by Me4Hik END
Conditions:
Price: 50 UAH per confirmed questionnaire.
Reporting: Provision of a daily list of unique respondents for verification.
To start working, I need to see your Google Form. Would you like me to prepare a script for automatic notification in Telegram about each new completed questionnaire so you can check them in real time?
