Google Sheets Freelance Jobs

I have around 200 addresses in Google Sheets. I need these addresses to be arranged in order so that I have the most effective route when I drive to all of them.

I need you to please use maps or whatever system you use, to make sure that all the addresses are arranged correctly. I tried to use RouteXL and I can upload all addresses, but it units/warehouses confuse it and it only gives the street name. Example 1/2-4 Hello St, Melbourne would show up as Hello St, Melbourne.

Please put the word "tiger" into your proposal so I can reject all the auto-applies. Please tell me how long you think this will take you.

Only people with great communication and fluent in English.

Thank you.

I'm in need of a proficient backend and API developer who can facilitate the transfer of structured text data. The data will be sourced from Google Sheets.

Key Requirements:
- Extensive experience in backend and API development.
- Proficient in handling structured text data.
- Familiarity with Google Sheets and its integration for data transfer.
- Ability to develop a seamless, efficient data transfer system.

Your expertise will ensure a smooth and reliable backend and API system for my text data needs.

Skills: PHP, Java, JavaScript, Software Architecture, MySQL

Small project requiring apps script to move data from 1 sheet to another via a submit button to create a record, clear data from the data entry sheet, and allow new data added to the data entry sheet to be added to the record sheet at the top, moving the previous data set down so latest data is always seen at the top and the records are always chronological.

We need someone to review job requirements and LinkedIn profiles and label whether the profile fits the given requirement.

In some cases, we need the person to explain as to why the profile is/is not a fit.

You will receive a batch every day to work through...

You must speak English fluently and have basic recruiting experience.

You must also be technically proficient and able to use platforms like Google Sheets, CrunchBase, LinkedIn, etc.

About Us:
Duo Digital (https://www.goduo.co/) is a marketing agency that primarily works with home service companies. Think roofing, solar, remodeling, moving, etc.

We are seeking a talented Paid Media Manager to join our team, focusing on managing and optimizing paid media campaigns for our diverse client base.

Role Overview:
As a contract Paid Media Manager, you will be responsible for setting up and managing campaigns across Google Ads and Facebook Ads platforms. Your role will involve creating and optimizing client campaigns end to end (conversion tracking, campaign set up, optimization, reporting.)

You will work closely with clients and your account manager to communicate campaign performance and provide strategic recommendations for improvement. \

Key Responsibilities:
- Set up and manage Google Ads and Facebook Ads campaigns for clients.
- Develop and optimize lookalike audiences and conversion tracking.
- Create and maintain performance reports, updating weekly trackers.
- Utilize Google Sheets to analyze data and track campaign performance.
- Set up offline conversions using Zapier.
- Communicate effectively with clients, providing clear and transparent updates on campaign performance.
- Collaborate with the team to develop and implement strategies for campaign improvement.
- Manage multiple client accounts, ensuring high-quality service and performance.

Skills and Requirements:
- Expertise in home service advertising is a HUGE plus (solar, roofing, construction, moving)
- Expertise in Google Ads: Proven experience in setting up and managing campaigns.
- Experience with Facebook Ads: Ability to create and optimize campaigns.
- SaaS experience: Preferred experience working with software companies.
- Analytical Skills: Proficiency in Google Sheets for data analysis.
- Zapier Knowledge: Experience with setting up offline conversions.
- Client Communication: Strong interpersonal skills and ability to communicate effectively with clients.
- Understanding of US Home Service Businesses: Knowledge of the industry and lead acquisition strategies.
- Reporting Skills: Ability to create detailed and insightful performance reports.
- Organizational Skills: Ability to manage multiple clients and campaigns simultaneously.
- Full-Time Availability: 20-40 hours per week, depending on client load.

If you are a results-driven individual with a knack for paid media and a passion for helping local businesses grow, we encourage you to apply. Join us at duo Digital and be a part of our fast-growing team!

I am seeking a highly skilled Google Data Studio expert to build a comprehensive dashboard in Google Sheets. The dashboard should display the following metrics to provide valuable insights and analysis:

Please watch the full explanatory video here: https://www.loom.com/share/b11973dd41d44293a362137a7c89de08?sid=46ad2b23-8da1-44e4-9027-6e4ec3a616d0

Share the link of your portfolio

We are seeking a skilled and detail-oriented skip tracer to help us locate and verify contact information for a list of lenders. The ideal candidate will have experience in skip tracing, data research, and using various online resources to find accurate and up-to-date contact details. This project involves gathering email addresses, phone numbers, and physical addresses for a specific list of lenders.

Responsibilities:

Conduct thorough online research to find contact information for lenders from lists that will be provided.
Utilize various tools and resources, including professional directories, public records, business databases, and other relevant platforms.
Verify the accuracy of the gathered information from multiple sources.
Document the findings in a structured format (Excel or Google Sheets).
Maintain confidentiality and handle sensitive information with care.

Requirements:

Proven experience in skip tracing, data research, or a related field.
Familiarity with online databases, professional directories, and public records.
Excellent attention to detail and organizational skills.
Strong communication skills and ability to provide clear and accurate reports.
Ability to work independently and meet deadlines.
Preferred Qualifications:

Experience with specialized skip tracing tools like LexisNexis, TLOxp, or Accurint.
Background in real estate, legal research, or a related industry.
Previous experience working with confidential or sensitive information.

Project Details:

Scope: Research and verify contact information for lists of lenders to be provided to you. (We will start with an initial list)

Deliverables: Completed spreadsheet with accurate email addresses, phone numbers, and physical addresses, and any notes that are important for each lender.


How to Apply:
If you have the expertise and experience needed for this project, please submit your proposal with the following:

A brief overview of your experience in skip tracing and data research.
Examples of similar projects you have completed.
Your approach to ensuring the accuracy and completeness of the information.
Your availability and estimated timeline for project completion.
Your proposed rate or total cost for the project.
We look forward to working with a dedicated professional who can help us gather the necessary information efficiently and accurately. Thank you!

Looking for a Project Coordinator to assist with data entry, research, and email communication. This individual will work with an Account Manager on multiple projects and must have strong organization and project coordination skills.

Key Responsibilities:
+ Data Entry: Proficiency in data entry. Efficiently input and manage large volumes of data in Google Sheets/Excel, ensuring accuracy and integrity of information. Proficient knowledge of Google Sheets (or Excel) within Google Workspace is a must.
+ Communication & Research Apptitude: Ability to communicate clearly with team members & conduct online research.
+ Data Analysis: Review and process reports for quality assurance & accuracy purposes
+ Scheduling: Managing a schedule and in some cases, making calls to US-based businesses (scripts & training will be provided)


Requirements:
+ Must be in timezones that coincide with US timezones +/- 1 to 2 hours max
+ Must be available to work weekends
+ Exceptional English Proficiency: Strong written, spoken, and reading comprehension skills in English are essential for this role.
+ Strong organizational and time-management skills, with the ability to prioritize and manage multiple tasks simultaneously.
Excellent verbal and written communication skills, with the ability to effectively present ideas and communicate with clients, staff, and internal stakeholders.
+ Detail-oriented mindset with exceptional problem-solving and analytical skills.
+ Ability to thrive in a fast-paced, deadline-driven environment while maintaining a positive and professional attitude.
+ Proficiency in using productivity tools such as Microsoft Office Suite (Word, Excel, PowerPoint) and project management software.
+ Proficiency with Google Sheets and other Google products.


If you are a proactive individual with a keen eye for detail and possess the necessary skills to manage a variety of tasks, we invite you to apply for this exciting opportunity. Join us in making a meaningful impact in our dynamic work environment.

I'm looking for an experienced administrative professional, who can help me to manage the back end of our residential and commercial power washing company. This role will interface with the owner and customers on a regular basis.

Below, are some of the tasks this role will be responsible for:
1. Helping customers with regular requests and queries about the company, and services, via phone, email and social media.
2. Making outbound calls to residential and commercial customer regarding services
3. Completing estimates using our standard pricing tool
4. Creating semi-custom proposals for commercial prospects
5. Updating google sheets trackers and reports
6. Other duties consistent and customary of someone with the role of Office Administrator or Administrative Assistant


Skills that will help this person to be successful:
1. Excellent english communicator both written and verbal
2. Knowledge of G-Suite and Google Workspaces
3. Experience working with residential home service businesses
4. PLUS - Experience appointment setting

I have a google sheet with 6 tabs- the content is already set up.
I need someone who is proficient in google sheets to set up a specific formula.
When the respondent fills out the google sheet on each tab, I want their answer to auto-populate on a master list in sheet 7.
The deadline is Sunday 28/07/2024 as I need this for an event next week.

Primary Objectives of the Social Media Marketing Content Creator
- Create high quality short form videos in a timely and efficient manner.
- Create high quality motion graphics work.
- Carry out and attain the mission and the goals of the studio in - terms of quality and customer service.
- Bring creative concepts to life through compelling designs and videos.

Video Editor Responsibilities
- Deliver high quality videos in a timely manner to the Creative Director and Studio manager.
- Listen to creative direction and innovate based on scripts to come up with uniquely artistic videos.
- Adhere to clients feedback.
- Maintain transparent communication. Appropriately communicate organization information through department meetings, one-on-one meetings, and appropriate email, IM, and regular interpersonal communication.

Primary Responsibilities of a Graphic Designer
- Create visually appealing and on-brand designs for various marketing materials, including digital and print assets such as social media graphics, website banners, brochures, infographics, presentations, and advertisements
- Conceptualize and create engaging and innovative visual content for social media platforms, website banners, blog posts, and other marketing channels.
- Collaborate with the marketing and editing teams to develop creative concepts and ideas.
- Optimize graphics and videos for different platforms, ensuring compatibility, fast load times, and optimal user experience across various devices.
- Stay updated on the latest design and video editing trends, techniques, and software.
- Maintain a well-organized digital asset library, including graphics, video files, project files, and stock imagery. Adhere to file naming conventions and ensure easy accessibility for future use.

Graphic Designer / Video Editor Job Requirements
- Excellent and efficient computer skills. (SPECIAL NOTE: Must have a robust computer that is efficient and able to deliver and export 4k videos in a timely manner.)
- Proficiency in graphic design software (Adobe Creative Suite: Photoshop, Illustrator, InDesign) and video editing software (Adobe Premiere Pro, Final Cut Pro, or similar).
- Experience with other animation and motion graphics applications is a big bonus.
- Experience and efficiency with all G-suite applications and documents including but not limited to; Google docs, Google Sheets, Google Decks, etc.
- Good written and spoken and communication skills.
- Experience in a team-oriented workplace preferred.
- Demonstrated knowledge of basic economics, budgeting, and accounting principles and practices.
- Demonstrated ability to serve as a knowledgeable resource to the organization's management team.
- Evidence of the ability to practice a high level of confidentiality.
- Excellent organizational management skills.
- Proven experience as a Graphic Designer and Video Editor, preferably in a marketing or creative agency setting.
- Solid understanding of design principles, typography, color -theory, and visual storytelling.
- Knowledge of video production processes, including shooting, lighting, sound, and editing.
- Strong attention to detail, accuracy, and ability to meet deadlines.
- Familiarity with social media platforms and their respective design requirements.
- Ability to adapt to changing project priorities and work effectively in a fast-paced environment.

Education and Experience Required
- Minimum of a Bachelor's degree or equivalent in a creative school for film.
- A minimum of three years of experience in video editing, or a strong portfolio, with both short and long form formats.

Physical Demands of the Job
- These physical demands are representative of the physical requirements necessary for an employee to successfully perform the essential functions of the Video Editor's job. Reasonable accommodation can be made to enable people with disabilities to perform the described essential functions of the Video Editor's job.

While performing the responsibilities of the Video Editor's job, the employee is required to talk and hear. The employee is often required to sit and use his or her hands and fingers, to handle or feel.

The employee is occasionally required to stand, walk, reach with arms and hands, climb or balance, and to stoop, kneel, crouch or crawl. Vision abilities required for this job include close vision.

Job Types: Full-time, Part-time

Expected hours: 20 – 40 per week

Schedule:

Monday to Friday

Application Question(s):
- Please share links to video editing samples and portfolio of graphic design work. Looking for 30-60 second format and 1-2 minute format. Both artistic montages and interview intercut with b-roll.

Education:
Bachelor's (Preferred)

Experience:
Adobe Premiere: 3 years (Preferred)
Video Editing: 3 years (Preferred)
Work Location: Remote

READ FIRST!!

Looking for a talented and bilingual (English and Spanish) Sales & Customer Service Rockstar to lead customer service, business development, and schedule for a cleaning business based in Florida. You must be a highly independent, confident, and charismatic seller. Resourceful, reliable, tech-savvy, meticulous, detail-oriented, a fast learner, take initiative, think creatively, have ideas, and innovate. This opportunity is highly dynamic, highly demanding, and highly rewarding for the right person! Must have seller and hustler mindset!

Required:
Experienced in customer service and sales. Speaking with clients, gathering requirements, selling services, scheduling work, managing calendars of multiple staff.

Preferred:
Experienced with Airtable is a plus
Experienced with home service business is a plus (cleaning, HVAC, plumbing, etc)
Experienced with Google Suite - Google Calendar, Gmail (labels and rules), Google Docs, Google Sheets.
Experienced with Slack
Experienced with a VOIP phone system. Dialpad is a plus.
Experienced in multi-tasking rapidly across all these tools.

I have around 110 rug images. I want you to insert them into google sheets cells. "Insert image in cell" , not "Insert image over cell"

Looking for someone with excellent attention to detail and experience with Google Sheets.

I'm creating a spreadsheet to keep track of the videos on my YouTube Channel. I need someone to go through my library of over 150 videos, and record the following information about each one into a spreadsheet that I've already created: video title, youtube link, # of views, the playlist(s) it's in, whether it's public or private.

This is a simple job, but must be done 100% accurately!

Resource Hub Build-out

Background:

The current WordPress site is built with Elementor.

We want the ability to add resources posts (built off of provided elementor templates) to our resource hub index page. Custom form logic should be, ideally, built onto the pre-existing custom WordPress plugin (carwars.)

The form currently submits input data to google sheets integration and to our internal API gateway via POST (in json data packets.)

There is a partial CMS built out with some of the features already present, we would ideally base new work off of that, but open to a scratch build if the resources turn out to be more efficient.



Acceptance criteria:

1) Ability to add resources posts from WP Dashboard (Partially Present):
- Pages/posts can be tagged to one or multiple categories (feature already present.)
- Categories display visually in the resource post title
- Each post is based off provided Elementor templates. A user can select which template, with new templates able to be added in the future. Individual posts must be able to be edited in Elementor.

2) Able to redirect to specified URL after form submission.
- Able to accept arbitrary URL string.
- Use a standard UI to enable redirect and set URL (Partially Present).
- Ability to configure if link opens in a new tab or in the current page.

3) Able to display hidden (gated) content after form submission (Partially Present).
- Content will be hidden before form submission and displayed upon successful form submission.
- Page should be on the same URL with mechanisms (ie. URL variable) to allow for direct links to gated content.
- Hidden content can replace existing content upon submission.

4) Maintain all existing functionality of custom formfill plugin.

Time estimate: 6+ hours

We are seeking a detail-oriented Virtual Assistant/Data Entry Specialist to assist with collecting address information from a specific website and entering it into a Google Sheet. This project involves approximately 200-300 entries that need to be accurately compiled.

Responsibilities
- Visit the provided website to collect address information.
- Enter the collected addresses into a Google Sheet with high accuracy.
- Ensure all data is correctly formatted and organized.

Requirements
- Proficiency with Google Sheets.
- Strong attention to detail and accuracy.
- Ability to complete the task in a timely manner.

Project Timeline
- Estimated completion time: 1-2 days.


If you are a reliable and efficient individual with a keen eye for detail, we would love to hear from you. Please include any relevant experience in data entry or virtual assistance in your application.

Bay Psychology Group, Inc. (https://www.baypsychologygroup.com) is seeking a reliable and organized Administrative Assistant to join our team. This is a fully remote role. The ideal candidate will possess strong organizational skills, effective communication, and the ability to manage a variety of tasks. Bilingual proficiency/fluency in English and Spanish is required.

Duties and responsibilities:

Schedule Management (2 hour per week):
-Manage the CEO's schedule, coordinate meetings, and send reminders for deadlines.
-Use Trello or other software to track tasks and organize information for the team. Ensuring that no protected health info is posted to trello as it’s not HIPAA compliant
-When booking appointments in the calendar for employees, job applicants, colleagues, ask which topics they would like to discuss and put them in the calendar description for CEO so he can prepare. Also, ask for a backup phone number in case they are not able to be reached via google meet.
-1 hour weekly meeting with president on fridays at 9AM to discuss business tasks, provide updates, etc. Should follow the format of email/trello with all new tasks added to trello and detailed notes of the meeting uploaded to a google doc titled “Admin meeting XXX date”. Investigate if we can automate/streamline by having trello update to google doc.
-Provide a weekly agenda for a weekly meeting with the President highlighting any emergent tasks/issues, details on progress, and to receive new duties or assignments.

Communication (1 hour per week):
-Respond promptly to incoming messages, ensuring same-day responses for urgent or routine communications, except on weekends or holidays. Such messages may include responding to requests for services.
-Oversee company social media accounts, including content posting and community management.
-Serve as a liaison for English and Spanish communication within the Company.
-Manage president’s email and communications that are non-clinical with a summary delivered each afternoon at 1pm. The summary should have any messages requiring my response highlighted at the top of the email, with details about what needs to be decided. Such messages should be ranked by urgency. Urgency may be approximated if it relates to payments due or other matters of money, personal matters or illness from employees, compliance/legal issues, or deadlines that are less than 1 week away.

Hiring (2-4 hours per week):
-Post and manage job ads on recruitment platforms. We used both our website and Indeed. We work from a unique perspective and we’ll train you on some of the basics about what makes BPG unique. Job ads will need to align with our current openings, referrals, and company values/culture.
-Send screener questionnaire to applicants selected by the president
-Conduct initial interviews after screeners have been completed and the president has decided to proceed.
-Assist with onboarding new hires, including contracting, credentialing, and ensuring completion of all necessary forms
-Oversee onboarding new hires via Trello, Gusto, Spruce, TherapyNotes
-Oversee contracting and credentialing for new hires, including updating the group roster for each payor, updating CAQH/Availity
-Onboarding new hires: create email accounts for new hires in Google admin, therapynotes, spruce, CAQH, create timecard and payment calculator in google sheets, ensure NPI taxonomy is correct, familiarize with and ensure usage of lastpass, get bio and testimonials from new hires for website. Create psychologytoday profile for clinician.

Administrative Support (4-6 hours per week):
-Support event planning and coordination for internal and external events.
-Weekly bookkeeping using Wave and bi-weekly payroll using both Gusto and Google Sheets.
-Perform other administrative tasks as needed/assigned.
-Onboard patients once intakes are completed by creating Spruce and TherapyNotes accounts for patients. Send patients intake paperwork via the TherapyNotes “Patient Portal” and communicate with the clinician once these tasks are complete. Intakes will be completed by associates and are expected to be scheduled within 24 hours of initial contact. The associate will communicate the status of intakes via the google referral database. It will be the VA’s responsibility to check this daily and respond to intakes that indicate they have been completed and are ready for accounts and documents to be setup/shared.
-Proactively monitor and update company handbooks, consent forms, as needed
-Looks for opportunities to increase efficiency, reduced duplicating efforts, etc.

Payroll/Bookkeeping (4 hours per month):
-Track reimbursements for employees (internet usage and continuing education credit usage)
-Run payroll every two weeks in Gusto. Ensure timesheets are completed 1 day prior to payroll deadline by messaging the team several days in advance about when timecards are due and proactively provide the president with payroll totals the same day to ensure sufficient funds are available.
-Update payment calculators when new fees schedules are available. For medicare this is every new calendar year, and for SHIP and Anthem this is whenever negotiations are successful

Medical Claims (1-2 hours per week):
-Submit medical claims daily at the end of the day within TN. The “submit claim” tab will allow you to select any claim that is “pending initial submission”. Claims that have data issues, are resubmissions or otherwise are not ready for initial submission, should be investigated. Any notice that outstanding notes are preventing a claim from being submitted should immediately be brought to both the clinician’s awareness and to the president’s. Track this and follow up within 24 hours with the clinician to ensure timely completion.
-Track down and follow up on unpaid medical claims, or rejections. Running aging reports will be essential for this task. For rejections consult the ERA for errors and details for the rejection. Ensure all insurance information is accurate and current. Contact clinician to verify no changes in pt information or insurance. Follow up with TherapyNotes support or payer support as needed. When contacting payers for any reason the date, time, and person you are speaking to must be recorded in writing. Ask for a reference number from anyone you speak to.
-Retrieve, reconcile, and post ERA’s to patient charts weekly (for most payers this is down directly in TN. For Globe Life and SHIP this is done externally. See handbook for details).
-Verify patient insurance details and benefits when onboarding new pts

Billing (1-2 hours per month):
-Oversee the clinician’s timely collection of payments by running monthly aging reports in TherapyNotes
-Collect/bill/invoice patients for balances due for any caseload while a clinician is unable to (i.e., therapist has left the company, they are on vacation/leave, etc.)

SEO and Marketing and Website (2 hours weekly):
-Implement our social media marketing strategies.
-Manage and update social media accounts via buffer/wordpress
-Optimize website SEO and explore utilizing AI (within Wordpress and ChatGPT) for improving SEO. When using AI no patient information can ever be used.
-Add or remove clinician bios upon hiring or firing
-Create and pursue opportunities for Backlinks
-Investigate and use CRM to build a distribution list segmented for our different audiences

Record Keeping and Compliance (2 hours weekly):
-Keep detailed records of all tasks performed on the Company's behalf, providing a weekly summary to the president due thursday at 1pm in preparation for the weekly admin meeting on fridays at 9 am. The format should be brief and in the form of an email. Tasks details should be listed in Trello as well with their current status indicated per card.
-Track employee office utilization, patient retention rate, and other company/employee efficiency metrics, proactively reporting any trends that do not meet expectations. This will be reported on the google sheet titled “KPIs”.
-Send patient surveys quarterly to monitor a high level of patient care.
-Send employee satisfaction surveys quarterly
-Update KPIs in google sheets monthly.
-Ensure compliance with HIPAA and other regulatory requirements, maintaining confidentiality and security of sensitive information.

CEO of multiple small business is looking for personal virtual assistant.
Part time to start 15-30 hours per week
Can become full time.
Tasks to include but not limited to:
Social Media Management
- creating, designing posts, videos, stories; instagram, facebook, tiktok, linkedin
- managing social media messages
- email management
- working on, creating, completing reports via excel / google sheets
- Go High Level Experience a PLUS
- Photoshop, Canva, ChatGPT, Adobe Illustrator a PLUS
- helping with general tasks that can be done with remote
- quick communication via Whatsapp
- general communication via email and google sheets.

Can turn into something long term for right person. Also have several start up businesses in the works so lots of misc stuff to do.

I need someone to immediately organize and manage my CEO's schedule and bookings. Your primary tasks will be: - Scheduling and booking calls on the CEO's calendar - Reviewing and organizing past bookings on Calendly, extracting and creating a database of leads - Managing GoHighLevel to generate sales leads - Organizing and maintaining a database of leads using Excel/Google Sheets This is an urgent project, so I need someone who can start immediately and work efficiently. Experience in scheduling, CRM management, and lead generation is highly desirable. Key Skills: - Scheduling and calendar management - CRM management, specifically GoHighLevel - Data organization and management in Excel/Google Sheets - Lead generation experience is a plus

Skills: PHP, Data Processing, Data Entry, Excel, CRM

1. a counter that gives the number of results to download and total results
2. Google Sheets Export does not work
3. Scrape email from website

We are seeking a detail-oriented and tech-savvy freelancer for a one-off project to help us create a comprehensive report of our Google Drive folder hierarchy. The ideal candidate will be able to provide a clear and organized list of our current folder structure and set up a system to easily generate updated reports in the future as our Google Drive evolves. The ideal candidate should possess in-depth knowledge of Google Sheets and have a proven track record of developing efficient and effective automation solutions.

Responsibilities:
Analyze our existing Google Drive structure to map out all folders and subfolders and files not in folders.
Create a detailed report listing the hierarchy of folders in an organized format.
Implement a method or tool to easily update and generate new reports of the Google Drive hierarchy as changes occur.
Provide clear documentation and instructions for running future reports.

Requirements:
Proven experience with Google Drive and Google Workspace.
Strong organizational and analytical skills.
Extensive experience with Google Apps Script that can automate the generation of folder hierarchy reports.
Attention to detail and the ability to troubleshoot and debug scripts.
Attention to detail and ability to present complex structures in a clear and understandable manner.
Excellent communication skills and ability to work independently.
Preferred Qualifications:
Previous experience creating similar reports for other organizations.
Knowledge of data management best practices.
Ability to deliver within a specified timeframe.

Deliverables:
A comprehensive report detailing the current Google Drive folder hierarchy.
A tool or method for generating future reports, along with clear documentation and instructions.


How to Apply: Please provide a brief summary of your experience with Google Drive, particularly related to organizing and documenting folder structures. Include examples of similar projects you have completed, if available. Additionally, outline your approach to this project and any tools or methods you would use to accomplish the task.

We are looking to add a new member to our estimating team. We are looking to hire and train a new estimator assistant for our estimating department. This is a 100% remote work opportunity. Full training is provided. The job consists of reviewing architectural documents and construction documents to find windows/openings to measure and price out.

Ideally looking for someone who is very detail-oriented, great with numbers, great with google sheets, and is self-motivated. A high level of English speaking is preferred.

This is a long-term employment opportunity and we are looking for someone to grow with us.

I'm looking for a data analytic expert to take the data I've acquired from google sheets and put it all into a platform like TableU where I can visually see what numbers align with one another. I can explain in further detail what is required over a call.

We're looking for a romance novel writer / editor to join the team behind a potentially long term romance novel book series.

Must be excellent with grammar and an avid reader of popular romance novels via Kindle Unlimited.

Must be familiar with google drive, google docs, google sheets and the Kindle Direct Publishing platform.

We are moving on an accelerated timeframe and candidates should be quick, fast and able to type 60-80 words per minute.

Ideal candidates should have basic knowledge of AI tools for writing.

Needed: Personal Finance Dashboard on Google Sheets (Data Visualization)

Description: I’m a personal finance educator and I need a Google Sheets dashboard created for my clients to help them keep track of their money coming in and going out. Specific details below.

Important note: this dashboard may be sold to clients so the expert who takes on this job must provide the rights and permissions for this.

1) Instructions tab (instructions on how to use the template)

2) Monthly Tabs (January to December)
- Income (date, amount, source). This should include a pie graph that illustrates income streams.
- For “source”, there will be multiple options like paycheck from job 1 and 2, side hustle 1 and 2, pay back from friend/family, work expense reimbursement, medical benefit reimbursement, and a few misc. fields that the user can customize.

- Expenses (with a pie graph that illustrates the categories for individual purchase categories and bills).
Monthly recurring bills: Date, name of bill/company, amount budgeted, amount spent, description. The user should be able to add this to one master sheet and it should automatically copy onto every month’s sheet. If the user has gone over/under the budgeted amount, there should be something that signifies this (such as “variance” column that has red text and the amount gone over if over, or green text that highlights amount under, if under).
- Individual purchases: Date (calendar prompt), amount, description, category (drop down list with category options that the user can customize such as entertainment, transportation, health, beauty, etc.).
- Savings & Investments (opportunity to input how much they’ve contributed towards their savings & investments goals)
- Debt Repayment (opportunity to input how much they’ve contributed towards their debt payoff goal)
A graph for “budgeted vs. actual” spending

3) Savings & Investments Tracker Tab
The user should be able to list all of their individual savings goals, the overall amount of the goal, and the goal date. With that information, the spreadsheet should determine what amount they need to contribute monthly to meet the goal. There should also be a “progress bar” to tell them whether or not they are on track to meet each goal. This will be the main source of information that the “savings” section on each monthly tab pulls from.

4) Debt Repayment Tracker Tab
Similar to the saving tracker, the user should be able to list all of their debts, the amount of each, and the goal date to pay it off. The spreadsheet should determine for them how much they need to contribute each month to meet the goal, and there should be a progress bar. This will be the main source of information that the “debt repayment” section on each monthly tab pulls from.

5) Year to date (YTD) tab
This should be a single “dashboard” view that summarizes everything in the overall sheet:
How much income they’ve earned
How much their expenses have been overall, with one graph that breaks down each category for individual purchases, and another one that breaks down bills/fixed expenses
How they are progressing towards savings goals
How they are tracking towards debt repayments


Extras:
There should be an option to change currencies so users worldwide can use this
I will provide details for specific colours and fonts to use for the dashboard as they must match my branding

Description:
We are looking for a skilled Google Sheets expert to assist with compiling data sources and reconciling missing invoices. The ideal candidate should have extensive experience with Google Sheets, particularly in using date functions.

Responsibilities:

• Compile data from various sources into a centralized Google Sheets document.
• Reconcile bank statements with invoices to identify any missing invoices.
• Utilize advanced date functions to ensure accurate reconciliation.
• Provide regular updates on the reconciliation process and highlight any discrepancies.

Requirements:

• Proven experience with Google Sheets and advanced functions.
• Strong attention to detail and accuracy in data handling.
• Ability to work independently and meet deadlines.
• Excellent communication skills for reporting progress and findings.

To Apply:

• Share examples of similar projects you have completed.
• Detail your approach to data compilation and reconciliation using Google Sheets.
• Specify your availability and expected timeline for project completion.

I would like to clean up an OKR table in Sheets that I have created to make it more used friendly and ensure that people who are not me can use it easily.

I would like, for example, to:
1. Group cells
2. Have drop-downs to hide/unhide columns with sub goals
3. Recommendations on how to make it easier to use

E-Learning Content & Project Assistant
Remote Position / Part Time (15-20 hours per week)

About This Role
We are looking for a meticulous and adaptable part-time contractor to join our team. In this role, you will be instrumental in supporting the creation of professional training content by ensuring detailed execution of tasks, managing data across work artifacts, and maintaining organization in our file management systems. You will report directly to the Head of Learning and collaborate closely with different team members to support the creation of professional training videos and materials. This role is vital in maintaining the quality of our outputs and the smooth functioning of our day-to-day operations.

Duties & Responsibilities
- Follow detailed instructions to complete assigned tasks accurately and efficiently (we use Asana for project management).
- Work through and improve existing processes by nature.
- Adapt to new software and file types as required by different projects.
- Manage calendars, schedule meetings, and set reminders to keep projects on track.
- Organize and maintain digital files and ensure easy accessibility for the team.
- Conduct detailed proofreading to ensure the quality of documents (e.g., teleprompter scripts, transcripts, closed captions/subtitles).
- Support administrative tasks related to e-learning and learning management systems (e.g., Kajabi, custom LMS).
- Assist in the creation and organization of professional training content.
- Deliver clear email communications and follow-up with internal and external stakeholders.
- Work effectively in a virtual, remote environment.

Skills & Competencies

Organizational Skills
- Maintain a structured approach to handling multiple tasks and priorities.
- Efficiently manage digital files and documents for easy retrieval.
- Ensure all project deadlines are met through effective calendar management (we use Asana and Google Calendar).

Professional Communication
- Communicate effectively with team members and management.
- Provide clear and concise updates on task progress and project status.
- Maintain professional and courteous interactions with internal and external stakeholders.
- Conduct detailed proofreading to ensure the quality of documents.
- Attend live daily standups (9am, California time).

Adaptability and Learning
- Quickly learn and adapt to new software tools and file formats.
- Document new processes so someone else could replicate it.
- Show flexibility in handling various types of projects and tasks.
- Demonstrate curiosity and a willingness to learn new skills and methodologies.

Detail-Oriented Execution
- Ensure accuracy and attention to detail in all tasks.
- Follow through on assignments to completion and on time.
- Maintain high-quality standards in all outputs and deliverables.

Technical Proficiency
- Familiarity and experience with the following technologies:
- gSheets: Manage and analyze data in Google Sheets.
- Figma: Collaborate on design projects using Figma.
- gDrive: Organize and manage files in Google Drive.
- Gcal: Schedule and manage events in Google Calendar.
- Mural: Visual collaboration tool using Mural.
- Email: Strong email communication and follow-up skills.
- Teams. Zoom: Collaborate and communicate remotely.
- Descript: Edit and produce videos with Descript.
- Asana: Manage tasks and projects with Asana.
- Gdoc: Create and edit documents in Google Docs.
- chatGPT: Utilize ChatGPT daily for various tasks and support.
- Kajabi: Work with e-learning content on Kajabi.
- Video Player: Manage and use video players for content delivery including usage of closed caption / subtitle files
- LMS: Operate and support customized learning management systems.

Competencies

Navigate Uncertainty
- Learn quickly.
- Be comfortable with ambiguity.
- Say “I don’t know” without fear or shame.

Focus on the Customer
- Focus on customer needs and work backwards from there.
- Earn and maintain customer trust by working vigorously on their needs.

Fast, Data-Driven Decisions
- Once acclimated to the role, you will need to make your own decisions without waiting for approval.
- Our company culture dictates that the person who has the most information should make the decision. If that is you, you are responsible for making the decision.

Resourcefulness
- Be able to work with available resources. We believe that constraints generate opportunities for creativity, self-sufficiency, and invention.

Complete Responsibility
- Take responsibility. We don’t say “Not my job.” You are responsible for the outcomes defined by your role.

Excellence in Execution
- Raise the bar by continuously driving teams to deliver high-quality products, services, and processes.
- Fix problems early and communicate with others to make sure they stay fixed.
- Stay connected to the details, audit frequently, and be skeptical when metrics and anecdotes differ.
- Deliver high-quality results in a consistent and useful manner.

Trusting Communication
- Communicate key information clearly and concisely.
- Be able to read a room, determine if you are being understood, and ask questions if you are not.
- Have a high degree of transparency. Making a mistake is ok, but you should be the first person to point it out.


Joining our team as a part-time contractor offers an excellent opportunity to work in a dynamic and innovative environment where your organizational and analytical skills will have a significant impact. If you are detail-oriented, adaptable, and eager to support a team dedicated to innovation, we encourage you to apply.

# Functional and Requirements Document for WhatsApp API Message Automation Project

## General Description

### Objective
The objective of this project is to automate the sending of messages through the WhatsApp API to automatically assign orders to collaborators. Integration with Glide, Zapier or Make, Google Maps (Distance Matrix), and the WhatsApp API is required.

### Description
The system must calculate the driving distance from the order location to the photographer's location using the Google Maps API or alternatives like Bing Maps. Notifications will be sent first to nearby photographers and then to those farther away if there is no response. The order acceptance functionality should include state changes in Google Sheets and consider variable rates and costs per km.

## Project Phases

### 1. Requirements Submission, Budget Approval, and Contract
- Send this document with detailed requirements.
- Acceptance of the budget by the freelance developer.
- Create the contract on Upwork with the corresponding milestones.
- Implementation proposal by the freelance developer.

### 2. Feature Implementation
- Develop the functionalities described in this document.

### 3. Testing and QA
- Conduct quality and functionality tests.
- Fix any errors and make necessary adjustments.

### 4. Final Validation and Delivery
- Final validation by the client.
- Project delivery and milestone release on Upwork.

## User Stories

### User Story 1
**Description:** As an administrator, I want the system to calculate the distance from the order location to nearby photographers and send notifications first to the closest ones.

**Acceptance Criteria:**
- The system should calculate the distance using Google Maps API or Bing Maps.
- Notifications should be sent first to nearby photographers and then to those farther away if there is no response within 30 minutes.

### User Story 2
**Description:** As a photographer, I want to receive order notifications with "Accept," "Reject," and "Propose another date" buttons to better manage my assignments.

**Acceptance Criteria:**
- Notifications should include "Accept," "Reject," and "Propose another date" buttons.
- Upon acceptance, the system should update the state in Google Sheets and avoid duplications.

### User Story 3
**Description:** As an administrator, I want the system to consider variable rates and costs per km when sending notifications to ensure the correct prices are included.

**Acceptance Criteria:**
- The system should include variable rates and costs per km in notifications.
- Rates should be extracted from Google Sheets and correctly applied to each notification.

## Definition of Done

The project will be considered complete when the following criteria are met:
- The distance calculation and prioritized notification sending work correctly.
- Notifications include "Accept," "Reject," and "Propose another date" buttons.
- The system updates the state in Google Sheets correctly and avoids duplications.
- Variable rates and costs per km are correctly applied in notifications.
- All functionalities described in the user stories are implemented.
- The system passes all quality and functionality tests.
- All source files and necessary documentation are delivered.

## Concrete Steps

### 1. Initial Setup
- Download and review the existing project files.
- Configure the Google Maps API and WhatsApp API keys.
- Test current functionality and review the Google Sheets database.

### 2. Implement Features
- Calculate the distance using Google Maps API or Bing Maps.
- Develop the prioritized notification flow and program the 30-minute timer.
- Implement "Accept," "Reject," and "Propose another date" buttons in WhatsApp notifications.
- Update the state in Google Sheets upon order acceptance and avoid duplications.
- Include variable rates and costs per km in notifications.

### 3. Testing and QA
- Conduct exhaustive testing of all implemented functionalities.
- Document and fix any errors found.

### 4. Validation and Delivery
- Present the completed project for client validation.
- Make final adjustments based on client feedback.
- Deliver the project and release milestones on Upwork.

## Stack / Technologies to Use

- **Frontend:** HTML, CSS, JavaScript
- **Backend:** Node.js, PHP
- **Storage:** Google Sheets
- **APIs:** Google Maps API (Distance Matrix), WhatsApp Business API, Glide API, Zapier or Make
- **Libraries:** Axios, Moment.js
- **Integrations:** Google Cloud, WhatsApp Business API, Glide, Zapier or Make

## Proposed Schedule

### Week 1: Initial Setup
- Configure APIs and review the current state of the project.

### Week 2: Feature Implementation
- Develop the distance calculation and notification flow.
- Implement buttons and state updates in Google Sheets.

### Week 3: Testing and QA
- Conduct exhaustive testing and error correction.

### Week 4: Validation and Delivery
- Final validation, adjustments based on feedback, and project delivery.

## Frequently Asked Questions

1. **Where will the development take place?**
- Development can be done on the developer's local server, but it must be tested and validated on the client's server.

2. **Will access to the necessary APIs be provided?**
- Yes, access to the Google Maps API and WhatsApp Business API keys will be provided.

3. **What happens if errors are found during testing?**
- Errors must be corrected before final delivery. A support period will be included to resolve any post-delivery issues.

## Important Considerations

- **WhatsApp Message Template:** Define the WhatsApp API message template.
- **Assignment Verification:** Define the system to know if an order has been accepted and assigned to avoid duplications.
- **Notification Priority:** Define the protocol to send notifications first to priority photographers.
- **Specific Services:** Define how to handle orders for specific services that not all photographers perform.
- **Cancellations and Reassignments:** Define the flow for handling orders that are canceled and re-uploaded to the database.
- **Special Rates:** Define how special rates for each photographer for different services are applied.

This document will provide the freelance developer with the clarity and details needed to complete the project effectively and efficiently.

## Current State
**Phase 1:** [Link to Phase 1](https://drive.google.com/file/d/1AjYpO8PDF_ca2Luw_8bfcjQgrFy1SryV/view?usp=drive_link)

**Phase 2:** [Link to Phase 2](https://drive.google.com/file/d/1xcXB0o-PFNZqqr_Uo92Axk9ji9ZBhwVy/view?usp=drive_link)

Skills: Web Scraping, Google Maps API, API, Process Automation, Make.com

Hi I am trying to build and maintain a custom crm software using Zoho and deluge. I would like someone who is experienced as a Zoho developer to build custom function and provide automation in Google sheets and Zoho CRM. You would be responsible for thinking the workflow as well as the cost of operations for this task. Most efficient solutions would be considered best.
Feel free to ask me some questions and let's build something awesome!