Copy rows if condition met google sheets jobs
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring d...exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if...
I'm seeking a talented video creator to assist me in crafting a 3-4 minute video that encapsulates the journey of a young bride and groom. I need a FAST turnaround time and need the project completed by 5/24. Please do not bid if this deadline cannot be met. Key Requirements: - The video will take viewers on journewy of trwo young people with focus on recent relationship - Must be energetic and upbeat, reflecting the joy of a wedding celebration. - Captions should be simple and minimalistic, enhancing the storyline without overwhelming it. Skills and Experience: - Extensive experience in video editing, particularly emotional or celebratory content. - Proficiency in selecting and incorporating music to evoke desired emotions. - Prior experience with creating captions in...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice te...from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effectively a...
I have a file that was completed. However the designer as unable to make sure the background would print in navy blue. I am attaching the file but need to make sure the following directives are met for the background. Cyan and Magenta need to be 30% apart Need someone that can send in CMYK format Suggested Color for navy100, 91, 42, 59 The backdrop will be 8'8 in size
I'm in need of a Google Adsense expert to set up my account and ensure that my website is compliant with Adsense policies. Key Requirements: - Setting up Google Adsense account: I need help with the initial setup of my Adsense account to ensure it is done correctly. - Ensuring compliance: As I'm not sure if my website is currently compliant with Adsense policies, the freelancer should review my website and make necessary adjustments to ensure compliance. Ideal Freelancer: - Proven experience with setting up Google Adsense accounts and optimizing them for maximum revenue. - Good understanding of Google Adsense policies and experience in ensuring website compliance. - Communication skills: The freelancer should be able to explain the changes m...
I'm seeking a highly skilled professional to develop an Google Map API of my hotel. This API based project should include some distinctive customised data, such as: * Hotel Amenities: Don't worry about detailing each amenity, this was left vague on purpose. * Nearby Attractions: Not only should you include their names but also a description, how far they are from the hotel, and their rating. * Room Rates: Standard and peak rates. * Pickup and Drop Facility: A briefing about it * Cab Requirements: I do have some specific needs when it comes to this, but you'll learn more about them later. * "Book Now” Button: Yes, I even need a button on the map. Your experience in Google Maps API, data customization, and interactive design will be invaluable for th...
I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate:...that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time c...
...effectively set up Google Analytics on my Shopify store. This is crucial for my business as I aim to leverage the insights for various business objectives: - Tracking website traffic: Accurate data on website visitors will help me understand my audience, their preferences, and how they interact with the site. - Understanding customer behavior: By setting up Analytics to track user behavior, I can gain insights into what my customers are interested in, how they navigate the site, and what factors influence their purchasing decisions. - Improving marketing strategies: With Analytics, I aim to track the effectiveness of my marketing campaigns, understand which channels bring in the most valuable traffic, and optimize my marketing efforts accordingly. As I already have an existing ...
I'm in need of a Google Ads expert who can set up my campaign to specifically target a Business-to-Business (B2B) audience. Key Requirements: - Adjust Audience Targeting: I need the freelancer to adjust the targeting settings in Google Ads to exclude consumers and focus solely on businesses. This is crucial for the success of my campaign. - Optimize for B2B Conversions: The ideal candidate should have experience in B2B advertising. I want to ensure that the ad copy, creatives, and overall strategy are tailored for business professionals and decision-makers. Ideal Skills and Experience: - Strong Background in Google Ads: You should have a proven track record of running successful Google Ads campaigns with a focus on audience targeting. - B2B Adv...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring d...exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if...
...would need a thorough diagnosis and resolution. Additionally, I'm experiencing some uncertainty with my Google Merchant Center listings, but I'm not sure of the details. Key Responsibilities: - Diagnosing and fixing errors on my website - as the specifics of the issue are currently unknown, an analytical approach and problem solving skills will be required. - Troubleshooting and correcting any issues in my Google Merchant Center listings - this may involve identifying missing products, incorrect prices, or discrepancies in product descriptions. Ideal Skills and Experience: - Proven experience in website troubleshooting and error resolution. - A thorough understanding of Google Merchant Center and experience with product listings. - Excellent ana...
I'm currently experiencing an issue with Google Adsense on my WordPress site. I have not attempted any fixes yet. I'm looking for someone who's well-versed in this area to help me out. Key Points: - Fixing Google Adsense issue on a WordPress site - Must have experience in handling similar issues - I have access to the file manager, so you can make necessary changes Ideal Skills: - Strong understanding of Google Adsense and how it interacts with WordPress - Experience in resolving issues - Proficient in using WordPress file manager Please reach out if you think you can help.
I'm in need of an expert in Facebook advertising. My intention is to sell a yoga fitness course designed for both men and women aged 20-50, who are job professionals. The hired freelancer should: - Have a deep understanding of Facebook ads targeting - Be able to write compelling ad copy to engage potential participants - Have experience in crafting high conversion ads specifically for fitness or health-related courses Ideal Skills: - Facebook Advertising - Copywriting - Marketing Strategy - Experience in fitness industry (preferably yoga) marketing. Looking forward to your proposals!
I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed fu...
I am looking for a skilled Google Ads expert to help me run an effective campaign. - Ideal candidate will have expertise in all areas of Google Ads: Search, Display, and Video Campaigns. - The primary goal of this campaign is to increase website traffic. - The target audience for these campaigns is yet to be determined. The successful candidate should be able to provide insights on the target audience and develop a strategy that can effectively drive traffic to my website. You should be able to propose a campaign that can provide measurable results. The ideal candidate should have a proven track record of managing successful Google Ads campaigns, ideally for clients with similar goals.
**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to stay on team with better compensation. Sample tasks and responsibilities include, and are NOT limited to: 1. Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed...
I have 6 ph...editing. I have a (hopefully) temporary condition called Bell’s Palsy. This unfortunately came up right before graduation and has made my graduation photos something I am not excited to share. I need editing to make my face resemble its former state, of which I will attach a picture. Specifically, I need an expert with: - Proficiency in color correction and retouching. - Skills in facial structure manipulation, particularly in modifying eye shape, mouth shape, and ensuring symmetry on both sides of the face. This is a delicate and artistic task requiring precision in the reshaping of features without compromising the natural feel. Therefore, prior experience with such projects would be ideal. There is potential for additional pictures needing editing if...
...- Air-Shipping Time Duration: We’re looking for air-shipping time duration between 1-14 days. - Final Destinations: To make sure the shipping company can deliver the product from China till our clients doorsteps in GCC countries. - Efficient Handling Of Electronics & Clothes: You should be well-versed in handling electronic goods and clothes to ensure they reach their destination in optimal condition. - In-Depth Knowledge Of GCC Customs Regulations: You should be familiar with the customs regulations of Saudi Arabia, United Arab Emirates, Bahrain, Oman, Qatar, and Kuwait to ensure the smooth passage of the shipments. Ideal Candidate: - Proven experience in logistics and shipping, particularly with air freight. - A strong network in the logistics industry to secure ...
Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval
I'm seeking a seasoned Google AdWords specialist to help increase the traffic to my e-commerce website. Key Points: - I'm looking to drive more visitors to my site, helping to establish a broader online presence. - I am open to a strategy that will increase both quality and quantity of traffic to the site. - While the project primarily focuses on increasing website traffic, I'm also open to suggestions that can help boost conversions. Skills & Experience: - Strong expertise in Google AdWords and PPC campaigns with a proven track record of success. - Prior experience working with e-commerce businesses is a big plus. - Excellent knowledge of driving website traffic and understanding of e-commerce dynamics. - A creative and analytical approach to optimizing...
...Therefore, the graphics need to be tailored towards achieving this objective. - The tone of the graphics should be professional, authoritative and eye catching. They should exude a sense of trustworthiness, reliability and seriousness. - I envision the design to be simple and clean. The graphics need to be easily comprehensible and not overly intricate, while still maintaining a professional look. - Copy has been written and is attached to provide context. - Our website is: - Our platform for email distribution is Freshsales (sales automation and CRM). - Platform provides 169 templates that can be chosen or they can be custom designed. Ideal Skills: - Proficiency in graphic design, with a keen eye for aesthetics and attention to detail. - Experience in creating email campaigns
I'm in need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating with a proactive and skilled developer.
I am looking for someone that can design homes using SoftPlan software. I have already started the design & can email the SoftPlan files & digital PDF copy of the plan we need drawn.
I'm in need of an SEO expert who ca...search engine rankings for my 2 e-commerce sites Zen-Cart based shopping carts (both sites are pretty similar, both hosted on the same server). Key Requirements: - The website primarily consists of product listings (shopping cart) hence familiarity with e-commerce SEO is essential. - The focus of our SEO efforts will be on improving the search engine rankings to attract more organic traffic. Fix Google indexing and make sure there are no error pages. Skills and Experience: - Proven track record of improving search engine rankings for e-commerce websites. - Strong understanding of SEO principles and best practices. - Proficiency in keyword research and optimization. - Ability to work with e-commerce platforms such as Shopify or WooComm...
...drive results! Use the below information to craft the best billboard you can do! You may utilize some of the copy provided or create your own copy based on the information provided. Company/Service Information: • We are a US-based staffing agency that provides Virtual Assistant Services to micro-, small-, and medium-sized enterprises worldwide. • Our Virtual Assistants come from all over the world. • We have been in business for more than a decade. Our services: • Admin Support • Business Support • Marketing Support • Technical Support Industries we serve: • Construction • eCommerce • Finance • Healthcare • Hospitality • Insurance • Legal • Podcasting • Real Estate • And More! Some ...
I need a skilled developer to help me create a high-quality app sheet for the education industry. The main aim of this project is to increase my online vis...industry. The main aim of this project is to increase my online visibility and generate more leads. Key Features Required: - Primarily, the app must have quizzes and assessments. Ideal Skills and Experience: - Experience developing app sheets or similar software within the education sector. - Knowledge of incorporating interactive elements like quizzes into an app. - Strong understanding of how to optimize visibility online and generate leads. As an app developer on this project, you'll take on a pivotal role in creating a valuable educational tool. If you’re passionate about development and education, I...
...creates a post (see screenshot) - displays rows of 5 thumbnails (similar to Instagram) (see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot) Post condition static weight text - If the weight is equal to the previous logged weight (or if it is the first weight), give it an orange background color (see sc...
As an experienced data entry professional with three years of remote work experience, I am seeking new data entry opportunities from home. My expertise primarily lies in entering customer information, a task I have performed with precision and efficiency in the past. Key Requirements: - Data Entry: Primarily focused on entering customer information. - Software Proficiency: Proficient with Google Sheets. Ideal Skills: - Exceptional attention to detail. - Strong organizational and time management skills. - Previous experience working remotely. - Familiarity with other tools or software for data entry tasks is a plus.
I need to complete a complete a letter-copy editing project and deliver it within 8 hours.
I'm looking for a talented web developer to help improve my existing website. The changes I seek span across editing the design, content, and functionality aspects. (I just bought this from Astra Pro with Spectra, essential, Optimizer and YOAST - along with the Godaddy WordPress hosting) I have decent content from another of my sites to copy across to - Compress components with gzip Add Expires headers Make fewer HTTP requests Design Updates: - Changing colours: I want to refresh the colour scheme of the website to make it more vibrant and engaging - Updating fonts: The current font is outdated. I need a modern, sleek, and readable font to be implemented - Redesigning the logo: A logo redesign to reflect the updated color scheme and font Content Updates: - Updating
I'm looking for an experienced And...for an experienced Android app developer to assist me in finalizing my app for release on the Play Store. The app is already in development, but there are a few key tasks that need to be completed before it can go live. Key Responsibilities: - Finalizing the app for release on the Google Play Store - Assisting in resolving any existing bugs or issues - Implementing any last-minute changes or updates as necessary Ideal Skills and Experience: - Proven experience in Android app development - Understanding of the Google Play Store submission process - Ability to troubleshoot and resolve bugs effectively - Experience in handling last-minute app updates before release Please note that the specific features and purpose of the app will be ...
...projects and provide some documentation or proof that you were the original developer of those 3 websites please. Tech: Front-end Framework: React.js with and State Management + Typescript Styling: Tailwind CSS Back-end Framework: Node.js with Database: MongoDB Goals: Build a cryptocurrency gambling website from PSD + Figma designs and requirements provided and discussed (google docs/sheets). Must be fully secure and fully tested with no bugs or issues. Experience Needed: - Previous experience with Full Nodes ("Bitcoin Core" for Bitcoin and "Geth" or others for Ethereum) + understanding smart contracts - Previous experience making Desktop/Mobile responsive websites - Previous experience accurately converting a PSD design to a fully responsive ...
...paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and accuracy. 1. Google...
Create a tradingview script that: Show a candle from green >red>green and vice versa but the condition that second candele cannot close lower or higher than prior third candele cannot close under previous open.
I need a desktop software designed to help me collate an...popular New King James Version (NKJV) Bible verses and collation (into Excel or Google Sheets). The output must be in the NKJV and adhere to a strict protocol - The quotation - Source in a specified format (e.g. 2 Kings 3:2-5 - Maximum 55 words Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. We are happy to answer relevant questions for clarification. Ideal Skills: - Native English - Familiarity with the Christian Bible - both Old and New testaments - and various translations - Experience with Bible verse collation or similar projects would be a plus - Familiarity with Excel or Googl...
We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existi...
As the main user of a system integrated with Google Sheets and Zapier, I'm currently grappling with some performance issues. Concretely, there's a challenge with incorrect data output from our automated data and workflow program. I'm seeking an expert to: • Conduct a thorough audit and maintenance of our data-entry automation and workflows • Identify the root cause of the inconsistent output, and provide tailored solutions • Enhance the reliability of the system overall to prevent any future issues. Presenting a solid proficiency in Google Sheets, Zapier, and workflow optimization, your skills will indeed come in handy for the successful troubleshooting, rectification and enhancement of the system. Efficiency and a keen eye to det...
Hello everyone we are in need of new freelancer,s to handle a content writing and copy paste Job. Zero experience guidelines will be given (Beginners/experiences) Apply and get started as soon as possible
...tactics - Sports-specific drills to enhance your on-field performance - **Friday: Gym Work** - Strength and conditioning tailored to athletes - Improve endurance, speed, and agility 3. **Key Skills and Knowledge Gained** (Use attractive icons and short impactful phrases): - **Goal Setting:** Learn how to set realistic, measurable, and impactful goals. - **Peak Physical Condition:** Custom exercises to make you fitter, faster, and stronger. - **Mental Toughness:** Cultivate a winner's mindset to overcome challenges. - **Sports Specific Expertise:** Train with drills tailored to enhance football performance. - **Personal Development:** Track and measure progress, adjusting strategies to maximize effectiveness. 4. **Pricing and Call to Action:...
I am in need of a document management software that will be compatible with Windows& Mac. This software is int...particularly for Windows. The software should be designed to handle a large volume of documents while maintaining high performance. A strong understanding of cybersecurity and access control is also important to ensure the confidentiality of the documents. Once a document is scanned a title and name is given and physical copy filed into numbered box file. If document is required a quick search by name, title etc will reveal where the hard copy can be found as well as the digital copy can also be brought up. I will send the successful candidate a detailed description then it is up to the individual to develop the software. The scanning must...
...organization's income statements, balance sheets, and cash flow statements from the past year. Your expertise in financial analysis would be a big asset in this project. Key Tasks: - In-depth scrutiny of quarterly income statements - Detailed examination of balance sheets - Profound analysis of cash flow statements Please note, a comparative analysis among the organizations is not required for this project. Your focus should solely be on individual organization's financial health. Ideal Skills: - Experience in financial analysis and accounting - Detail-oriented with proven analytical skills - Ability to interpret complex financial data This job will require thorough analysis and a keen eye for detail, hence relevant experience is highly sought after. ...
I require professional assistance in notarizing a birth certificate issued in Mexico. The document is currently written in Spanish, and my requirement extends to getting it translated into English. The ...experience in legal document notarization, with a preference for birth certificates - Be fluent in both English and Spanish, to ensure precise translations - Possess background knowledge in Mexican legal documents, to understand the nuances involved. The task involves: - Notarization of the Mexican birth certificate - Complete translation of Spanish content to English - Ensuring the translated copy retains all legal relevance and accuracy Applicants should have experience in legal translation and notarization of documents. Fluency in both Spanish and English is key to thi...
Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and android. We are a web-development company that has developed a community platform that connects people and encourages them ...connects people and encourages them to support each other through sharing time, knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wishes
I have this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page;
I'm looking for a skilled artist who can create a replica of an existing image in a cartoonish style. The replication should closely resemble the original but with altered proportions or details. This new image will be used for digital purposes, such as on websites and social media. Key Requirements: - Replicate an existing image in a cartoonish style - Maintain a close copy of the original with altered elements - Ensure the final output is suitable for digital use Ideal Skills and Experience: - Proficient in digital art and illustration - Strong understanding of proportions, details, and shapes - Experience in creating cartoonish art - Ability to replicate existing images while adding a unique touch - Understanding of digital use and design principles Please provide example...
My primary focus is boosting product sales and traffic through Google Ads. Key requirements for this project are: - Strong skills in setting up and managing Google Ads campaigns. I'm keen on hiring someone who can optimize these adverts to maximize sales. - Experience with On-page SEO is essential. I'm looking at improving the visibility and performance of my website through effective on-page SEO techniques. - Understanding of e-commerce businesses. My main objective is to increase product sales, so having a background in similar projects or e-commerce businesses will be beneficial. A freelancer with a proven track record in improving sales using Google Ads and strong On-page SEO skills will be the perfect fit for this job.
I'm in the services industry and specifically offer tree service. My main goal is to increase our visibility on Google Maps in order to attract more customers. Key Requirements: - Improve our Google Maps ranking. - Use SEO strategies that are effective for local service businesses. Ideal Freelancer: - Experienced in local SEO and Google Maps ranking. - Has worked with service-oriented businesses before. - Understands the nuances of the tree service industry.
...The site will showcase and sell both physical and digital products. The main aim of this project is to get my products listed on Google Shopping through Google Merchant Center. The ideal candidate for this project should have: - Proficiency in Woocommerce site development - Experience in integrating Payu as a payment gateway - A track record of setting up and integrating Google Merchant Center with WooCommerce sites for Software Products. - An understanding of the intricacies of listing products on Google Shopping - Prior experience in setting up and managing online and in-store inventory on Google Merchant - Must be highly experienced to get approval on Google Merchant Centre and to fix Misrepresentation issues for website issues This project ...
