Poster Information Extraction to Google Sheet
Budget: $30 – $250 AUD
I have a collection of posters stored in a Google Drive folder (https://drive.google.com/drive/folders/1a0YCrgcFPUlLvj0pxi3Kg2sJrG2RZ4iv?usp=sharing), and I need a freelancer to help extract and summarize specific information from these posters into a Google Sheet (https://docs.google.com/spreadsheets/d/1_zSo-eHwthX0b_mDPPbiVpCYyYGOlyae2orZCA1Zccg/edit?usp=sharing). The details to be extracted may include event names, dates, locations, key speakers or performers, contact information, and any other relevant details that are consistently present across the posters. Note that one picture may contain multiple posters to be done.
The freelancer will need to:
1. Access the Google Drive folder where the posters are stored.
2. Review each poster carefully to identify and extract the relevant information.
3. Input the extracted information into a pre-formatted Google Sheet that I have provided. Each row in the sheet should correspond to a different poster, with columns for each type of information (e.g., event name, description, date, location, cost, etc.).
4. Contact Information Extraction:
4.1 Phone Numbers: Capture any phone numbers listed on the posters, ensuring that the numbers are complete and formatted correctly for easy reference.
4.2 Email Addresses: Extract any email addresses provided, making sure they are entered accurately and correspond to the correct event or organization.
4.3 Website: Include any websites or social media links mentioned on the posters, ensuring that the URLs are correctly typed and accessible.
4.4 Physical Addresses: If a physical location is provided, such as a venue or office, record the full address, including street, city, and postal code.
4.5 Contact Names: If specific contact persons are mentioned (e.g., event coordinators, organizers), include their names alongside the corresponding contact details.
Please organize the photos so that they are easy to navigate and analyze including moving posters into separate files where more than one poster currently exists in one file.
Attention to detail is crucial for this task, as the information must be accurately captured and properly categorized in the spreadsheet. Familiarity with Google Drive and Google Sheets is essential.
The freelancer will need to:
1. Access the Google Drive folder where the posters are stored.
2. Review each poster carefully to identify and extract the relevant information.
3. Input the extracted information into a pre-formatted Google Sheet that I have provided. Each row in the sheet should correspond to a different poster, with columns for each type of information (e.g., event name, description, date, location, cost, etc.).
4. Contact Information Extraction:
4.1 Phone Numbers: Capture any phone numbers listed on the posters, ensuring that the numbers are complete and formatted correctly for easy reference.
4.2 Email Addresses: Extract any email addresses provided, making sure they are entered accurately and correspond to the correct event or organization.
4.3 Website: Include any websites or social media links mentioned on the posters, ensuring that the URLs are correctly typed and accessible.
4.4 Physical Addresses: If a physical location is provided, such as a venue or office, record the full address, including street, city, and postal code.
4.5 Contact Names: If specific contact persons are mentioned (e.g., event coordinators, organizers), include their names alongside the corresponding contact details.
Please organize the photos so that they are easy to navigate and analyze including moving posters into separate files where more than one poster currently exists in one file.
Attention to detail is crucial for this task, as the information must be accurately captured and properly categorized in the spreadsheet. Familiarity with Google Drive and Google Sheets is essential.