How to pull data from multiple tabs in google sheetsJobb

I'm looking for a skilled web developer to create a game review website. This platform is intended to cater to two distinct user roles: moderators (who also function as admins) and regular users. Moderator/Admin User Features: - User Management: Ability to manage the users on the platform - Review Management: The capability to oversee and moderate game reviews - Dashboard: An intuitive, easy-to-use dashboard to help keep track of the website's activity and health Normal User Features: - Post Reviews: Simple, user-friendly functionality for posting reviews of games - Read Reviews: Easy access to other users' reviews of various games - User Profile: An individual profile for each user, where they can manage their review...

Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking...

...professional to build a system that creates aggregates Google business ratings for security installation services and Reviews for my site pages. Key Requirements: - Aggregating Business Ratings: The system should specifically focus on collecting the business ratings of security installation services available on Google. Data Points: The key data points that need to be collected include each business's overall rating and star reviews listed on Google SERPs. for Ideal Candidate: - Proficient in Web Scraping: Experience extracting and aggregating data from websites is essential. - Familiar with Google API: Knowledge of Google's API for harvesting ratings and review stars would be a plus. - Data...

I am looking for an experienced web developer to create a multi-format media player for my THC-based website: Here are some key details about the project: - Media Types: The player should support both mp3 and mp4 files. A seamless experience for both audio and video is crucial for my website visitors. - Required Functions: The primary functions I need are Play/Pause, Volume Control, and Playlist Management. The player should be user-friendly and intuitive to operate. - Integration: The player will be embedded on multiple pages of my website. It is important that it functions consistently across all pages and devices. The ideal candidate for this project will have: - Proficiency in web development - Experience in creating media players - Strong und...

...Dynamic website, and mobile app (iOS and android): Key requirement from developers: • Looking for a team of qualified developers with knowledge of all the functionalities required for this project • Must have expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/exper...

In need of a unique and creative cartoon-like illustration that unites a bulldog and a phoenix. This project is a gift intended for a school community friend. The goal is to craft a meaningful symbol of resilience, as the recipient has had a tough year. Key Elements: - Cartoon-like appearance - Coherent incorporation of a Bulldog and a Phoenix -the colors orange, black and white are the school colors Ideal Skills: - Highly skilled in cartoon illustration - Experience in incorporating multiple elements into one harmonious piece. - Ability to convey concepts symbolically - Able to communicate and interpret client's vision efficiently. The perfect freelancer would have an eye for detail and a creative approach to symbolic repr...

...allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed within the dashboard interface. - Menu Navigation: Implement a user-friendly menu system that allows for intuitive navigation through...

We're looking to recruit a rockstar virtual assistant to execute admin tasks with SPEED. Plenty of room for advancement and long-term employment if you’re competent, hard-working, and efficient. Skills required: - Excellent English is a MUST - Knowledge of Google sheets - Basic knowledge of Wordpress - Flexibility with working time and hours Job roles include but are not limited to… - Scraping basic information from website lists - Navigate Wordpress and add needed information Note - put the number ‘88’ in your application so we know you’ve taken the time to read this description!! Required personal attributes: - Strong work ethic - Focus and efficiency - Great English skills Expect a long ...

I'm looking for a skilled professional to design and develop an innovative multi-vendor e-commerce platform, where multiple sellers can sell products directly from their respective warehouses. While PrestaShop has been a consideration, I'm keeping an open mind to different platforms that would best serve this concept. We will also need features to accommodate seasonal products available during specific times of the year. Key skills and experiences for the task include: - Proficiency in various e-commerce platforms. PrestaShop expertise is a bonus but not a requirement. - Experience in developing multi-vendor e-commerce platforms. - Understanding inventory management systems, particularly with multiple sellers each managi...

...knack for making informative how-to/tutorial videos or are you more interest in comparing videos? If so, we have an amazing opportunity for you to join our team and showcase your talents on our established YouTube channel. We're looking for individuals who can create engaging step-by-step tutorials for software, apps, and email marketing tools. Please note, these are not animated explainer videos; we require screen recordings. Requirements: - Proficiency in English (native speakers preferred) - Willingness to record your phone/computer screen, along with your voice - Ability to explain concepts clearly and concisely - Access to a high-quality microphone I'm looking for someone that: - That's able to work w...

I am looking for a data scraper to collect product information and pricing from various websites. Key Requirements: - The scraper should be able to collect data from multiple websites and be easily scalable as we might need to add more websites in the future. - The data to be scraped includes product title, description, and price information. - The scraper will need to be able to navigate through the websites and accurately collect the required data. - The scraper should be able to work efficiently and provide timely data updates. Ideal Skills and Experience: - Proficient in web scraping techniques. - Experience working with product data and pricing. - Familiar...

I'm on the hunt for an experienced logo designer who's capable of c...screen image for my property rental company: A&K Properties LLC. Though I am open to all colors, the design itself should be vibrant, professional, and truly capture the spirit of the real estate industry. Ideal Skills and Experience: - Proficiency in the latest graphic design software and technologies - A good understanding of the property rental industry - Previous experience designing logos/screen images in the business sector would be a plus For applications: - Please provide image options in multiple formats Deliverables: - I'd like the final logo delivered in JPEG, PNG, and SVG formats. Your creativity and ability to translate our company'...

I'm looking for someone to edit a series of short videos for me. The total duration of the videos is less than 30 minutes in total. Key Responsibilities: - Cut and trim clips accordingly - Add text overlays - Merge multiple clips into one video Requirements: - Proficiency in video editing software - Experience in adding text overlays - Ability to cut and trim clips effectively - Familiarity with merging multiple clips into a single video Please reach out if you have the necessary skills and are interested in this project.

I'm seeking a pro...professional with expertise in financial documents, specifically balance sheets and profit & loss statements. - You'd be responsible for updating these documents with new figures - no structural or comprehensive changes required. - The modification will be minor, focused on figures and data. - Your role is to maintain the integrity of the documents while reflecting the new information accurately. Ideal candidates will have experience in: - Financial accounting, specifically with balance sheets and profit & loss statements. - Attention to detail, ensuring accuracy in the modification process. - Proficiency with financial software/tools would be an advantage. Your expertise in this ar...

...looking to launch a Google and Meta Ads campaign, with the primary objective of generating more leads and sales for my business. The focus will be on a nationwide scale, giving our campaign a wide reach across the country. Here is what I specifically need for this project: - Ad Campaign Development: Coming up with effective Google and Meta ads that specifically target a certain age group to generate leads and sales. You'll need to craft compelling ad copies that can attract and engage this demographic. - Ad Campaign Management: It's not just about creating the ads, but also about managing them. The ideal freelancer should have excellent monitoring skills to ensure our ads perform optimally, making necessary tweaks and adjustments o...

...American Football event called Champions for Charity. We need an illustrator to make us a new illustration for this year's shirt. This should be a custom illustration, not modification of the provided files. Project details are below. 1. Deliverables - 1 editable illustrator file with illustration for front of shirt. Black and white line drawing with single color fill (red) 2. Last year's shirt is attached for reference. 3. The illustration should be of our mascot kicking a football (American football) over the stadium through the field goal posts (see attached sketch) 4. The stadium is already drawn, pull this from last year's file (attached ). Just need to change the year inside to 2024. 5. The illustration of the mascot kicking the ...

...developer to create an Android app and website to effectively manage orders, returns, and payments across multiple marketplaces including Amazon, Flipkart and Meesho. The project should essentially mirror the functionality of Wisdom OMS. Key Features: - Order Tracking: Real-time tracking and monitoring of all incoming and outgoing orders from the aforementioned platforms. - Inventory Management: Integrated inventory system that automatically updates stock levels in response to orders, ensuring accurate and timely management of product availability. - Payment Processing: Smooth and secure payment processing capabilities to facilitate transactions and revenue collection. - Returns Management: Effective returns management system that tracks...

...have modified the front end to support uploading data in and XLS format instead of JSON. The data parsing is working but we are looking to improve the data validation to alert the user of specific problems with their data they are uploading. Input data: Sheet 1: Work Order Tab Name, Address 1, City, State, Zip, Technician Sheet 2:Technicians Tab Name, Starting Address, Starting City, Starting State, Starting Zip, Ending Address, Ending City, Ending State, Ending Zip Some of these fields can be blank. Useful validation for the user will be required. See this documentation regarding the json format The XLS sheets will correspond to the "jobs" and "vehicles" data types in th...

I'm looking for someone to deliver 4000 YouTube views across two of my video links within 24 hours. The views need to be split evenly between the two links. The main purpose of this project is to simply increase the view count on these videos. Ideal Skills and Experience: - Experience with increasing YouTube views - Ability to deliver views within a tight timeframe - Understanding of evenly distributing views across multiple videos

I am in urgent need of an experienced developer who can create email templates that can work seamlessly across multiple platforms notably Gmail, Outlook, Apple Mail, and others within a month. We need these emails to render properly in these platforms. We will have our own designs. We have one standardized base template, with about 6-10 variations of that base template that we’d like to think of as “components”. Those templates will be put into SendGrid for use. * **Skills and Experience** * A demonstrated experience in creating robust email templates * In-depth knowledge of various email platforms including Gmail, Outlook, Apple Mail * Proven ability to deliver projects within a stipulated timeline ...

... it should be possible to change to a person which we want to measure the x,y,z position and output these values exactly like in the video. - Fully support implementing it on the Client's Jetson nano - It should run smoothly like in the video. So no lags or delays - If it doesn't work smoothly on Jetson Nano then we'll help the client implement it in Windows Reference video Remarks of the client: "When starting the program, it should detect and only measure the first person it sees and if I want to change that then I can click on another person who is also in the frame and then it should start measuring him. And all of that should be during the live video feed. And like I said if another person or multiple...

I'm looking for a Google Shopping expert who can help me boost the conversion rate and sales of my WooCommerce e-commerce store. My Store selling is Ayurvedic medicine men's category. Key Points: - The current conversion rate and sales volume of my store is low. I aim to significantly improve both. - The primary goals of this campaign are to increase my store's conversion rate and sales. Ideal Freelancer: - Experience with Google Shopping campaigns. - Proven track record of improving conversion rates and sales for e-commerce businesses. - Proficient in WooCommerce, as my store is built on this platform.

...native translators in various languages for a localization project regarding the FAQ sections of our apps. We will be sharing a Sheets file with the texts that contains HTML codes and placeholders, Therefore, this project requires a lot of close attention to detail and preferably, past experience working with HTML codes. The file has two tabs. The first one needs to be localized, while the second tab needs to be proofread. The tone of the translations should be friendly, inviting, and informal. The first tab is 1800-words-long, but a considerable amount of the answers has repetitions. The second tab is 932 words-long in English. Ideally, we will be asking you to install at least one of our apps and see the current translation ...

I'm looking for a skilled freelancer to help me clear my Windows application from our Git repository. We need to remove the application completely. The ideal candidate will have experience with Git and Windows, allowing them to seamlessly and efficiently remove the application from the repository. Key requirements: - Proficiency in Git and Windows - Experience with application removal from repositories - Attention to detail to ensure the removal is complete and clean

Help with repetitive data entry tasks. As a potential programmer, this project involves creating a local program capable of extracting a single line of data with multiple fields from a Google Sheet and transferring it to 10+ different multi-page website forms that require unique login information. Additionally, the program should generate PDF documents on the target websites based on the transferred data and save them with named files corresponding to the original Google Sheet. It is crucial to incorporate error handling, data validation, mapping, and security measures into the program. If you are interested in working on this project, please provide details of your relevant experience and approach for ens...

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I'm looking for a skilled professional to help me set up Google Ads for my WordPress webpage. Key Responsibilities: - Setting up Google Ads account for lead generation - Identifying the best keywords to target - Creating compelling ad copies - Monitoring and optimizing the campaign for maximum lead generation I need someone who has: - Proven experience in setting up Google Ads campaigns, especially for lead generation - Extensive knowledge of WordPress and its integration with Google Ads Please be ready to show examples of past successful campaigns. Your insights on strategy and proposed budget are welcome. Thank you in advance.

I'm in need of a Python developer to create a script that will convert data from a Google Sheet into individual text files. Key Requirements: - Data Handling: You should have experience in handling data from Google Sheets, and be able to efficiently transfer it to text files. - Unique ID Generation: The script should include a mechanism for generating a unique ID for each text file. This ID should be randomly generated. - Custom Header or Footer: Each text file should have a custom header or footer. Ideal Skills: - Proficiency in Python - Experience with Google Sheets API - Strong understanding of data handling and file creation - Knowledge of random ID generati...

I'm looking for a Wordpress developer to configure a theme Forrest theme to how I want it. The site is a photography site www.rupertwatts.com. The theme is all installed. However, I need the following: Home Page: To display the Ken Burns Slide show - I need to be shown where I can add my images. Portfolio: To show a drop down of the following, All, Early Years, Senior School, Sixth Form, Arts, Campus, Sport. I need to be shown where I can edit and add images to these portfolio pages. Blog: Single post, Full Width. I need to be shown where to add the blogs Contact Page to show address and email About page to show info about me. I'll add the content. I have a logo which needs to be added...

I am looking for a proficient PPC manager who has in-depth knowledge and experience with Google Ads. The ideal candidate possesses: - A strong understanding of Google Ads platform - Mastery in sales-oriented PPC strategies For this project, the focus is on the retail sector. Key responsibilities will include: - Planning and implementing Google Ads campaigns targeted at my specific audience - Turning the PPC campaigns into revenue-generating strategies - Monitoring campaign progress, adjusting tactics as required to maximize results If you have excelled in similar roles in the retail sector and enhanced ROI by generating sales or leads, I'd love to hear from you.

Brand Identity and Logo Design for 'Purely Personal' We are looking for a creative and skilled designer to help us develop a unique brand identity for our fashion brand, 'Purely Personal.' The design should be clean, elegant, and easily recognizable, featuring a minimalist logo that incorporates a Himalayan blue sheep and using triangles to convey a sense of individuality and connection. Project Requirements: Logo Design: Create a minimalist logo that includes an abstract representation of a Himalayan blue sheep. Color Palette: Use the specified color palette to ensure a cohesive and professional look: #3A0360 #6622BD #7063BF #D5CEFF Versatile Branding: The logo should be suitable for various platforms and branding materials, such as business car...

...am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills...

I'm looking for a skilled developer to create a chat responder for WhatsApp. Key Features: - **Multilingual Support**: The responder should be able to handle multiple languages. - **Varied Response Types**: It should generate predefined text responses and also dynamic responses based on user input. The ideal candidate for this project should: - Have experience working with chatbot development on various platforms, particularly WhatsApp. - Be proficient in programming languages that support dynamic text generation. - Be able to implement multilingual support effectively.

I'm looking for an SEO expert who can guarantee that my website moves to the first page of Google search results. Key project requirements include: - Currently, my website is not ranking on the first page of Google. - I'm specifically looking for both on-page and off-page SEO services. Ideal candidates should have: - Proven experience in moving websites to the first page of Google. - Expertise in both on-page and off-page SEO. - A solid understanding of the local market to help reach our target audience. Please provide examples of previous work and your strategy for achieving this goal.

I'm in need of a skilled UX/UI designer to help develop the interface for a health application. The project will involve designing for iOS, Android, and web browsers, so experience in cross-platform design is a must. See for the moment we need - application for , , , See video - Key Features: - Personalized profiles: The application will need to accommodate user information and preferences in a clear and user-friendly way. - Tracking and monitoring: The application should offer intuitive ways for users to track and monitor their health data. - Reminders and notifications: The design

I'm looking for an experienced video editor who specializes in vlog editing. Key Responsibilities: - Edit vlog content to be 10-12 minute cuts - Ability to join multiple cut segments into a cohesive viewing - Add creative transitions to ensure the flow of video Ideal Skills and Experience: - Proven editing experience with vlogging content - Understanding of vlogging style and dynamics - Proficient in video editing software - Able to work within tight deadlines A portfolio showcasing your vlog editing skills will be advantageous. Your attention to detail and creativity are essential for this project.

Code a dynamic input field feature for quick data entry of an items data facts (options). The goal is to streamline the input process for users, making it intuitive and efficient. Requirements: 1. Dynamic Input Fields: • Initially, a single input field is displayed. • As the user starts typing, a new input field is automatically added below. 2. Autocomplete/Autosuggestion: • Input fields should support autocomplete/autosuggestion from a provided array. • When the user starts typing, suggestions should be displayed in a dropdown list. 3. Handling User Input: • If the user highlights a suggestion and presses Tab or Enter, the selected suggestion should be entered into the field. -or- • If the user t...

...someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurat...

I'm looking for a professional to help me fix my sitemap on Google Search Console. Currently, I'm experiencing two issues: “Missing URLs in sitemap” and “Errors in sitemap.” Key Project Details: - Less than 10 pages are currently missing from the sitemap. - There have been no recent changes to the website that could have affected the sitemap. Ideal Freelancer: - Must have experience in resolving sitemap issues on Google Search Console. - Should have a good understanding of website structure and indexing. - Proficient in identifying and rectifying errors in the sitemap. - Strong communication skills to explain the resolved issues and ensure future sitemap stability.

I'm in need of a skilled designer who can take my content and branding elements and craft them into a visually stunning presentation. Key Requirements: - Google Slides: The format of the slides must be on Google Slides - Client Pitch: The primary purpose of these slides is to pitch to potential clients, so it's crucial they're engaging and convincing. - Creative and Engaging: I want the slides to be not just professional but also creative and visually captivating. Ideal Skills: - Proficient in Google Slides - Strong design skills, with a portfolio that demonstrates creative and engaging design - Understanding of client pitch presentations and how to structure them for maximum impact If you're a ...

I have a JPEG format logo that I need to have a transparent background. I also require this logo to be provided in both multiple sizes and a single high resolution size. The logo will be used for both print and digital purposes. Ideal Skills and Experience: - Proficiency in graphic design and image editing software. - Experience in converting and manipulating images. - Understanding of different file formats and their appropriate uses. - Ability to create high resolution versions of images. - Familiarity with both print and digital design requirements.

More details: What is the purpose of the feasibility study? To evaluate the economic viability of the proposed system as defined in the study objectives. Write-up of concept to be provided upon execution of NDA. To assess the environmental impact of using biogas instead of natural gas for greenhouses What is the primary source of food waste that will be used in the anaerobic digester? Produce markets and restaurants waste from urban centers What is the expected output from the anaerobic digester? Sustainable renewable Biogas

I'm seeking a talented designer to create a logo for Village of Glandorf. The key to this project is crafting a visual identity that balances both a community-focused attitude and a modern progressive vision. Skills and Experience Required: - Expertise in graphic design and branding - Excellent understanding of design aesthetics and balance - Ability to interpret and translate desired feelings and ideas into design Project Details: - The name of the township to be incorporated into the logo is "Village of Glandorf" - The township located in state of Ohio. - Creative design is your playground, as we are open to color suggestions, or use purple and gold/yellow. Use your imaginations. - The logo needs to reflect our com...

Keil Business Solutions GmbH is an innovative Google reseller and IT service provider. For a customer project we are currently looking for a Senior SAP PP Functional Consultant for TKE project (f/m/d) - Spain Roles & Responsibilities: • Facilitate the implementation and support of SAP PP ECC Roll-outs. • Perform detailed analysis of complex local business process requirements and provide appropriate system solutions; identify, interpret, validate and document customer requirements. • Facilitate workshops to collect local business requirements. • Map client business requirements, processes and objectives; develops necessary product modifications to satisfy clients' needs. • Design, customize, configure and testing of PP. • Ident...

I'm looking for a translator to adapt my English screenplay into Japanese. Though the tone is informal, accuracy is of utmost importance. Applicants should have expertise in the following areas: - Dialogue translation: Ensure idiomatic speech is authentically converted and makes sense in the target language. - Cultural nuance management: The screenplay references multiple localized subjects, which need to be accurately depicted for the Japanese audience. - Knowledge of technical terms: Some industry-specific terms need translation without losing their original meaning and context. The objective of this project is to localize the screenplay for the Japanese market in Final Draft. Therefore, a solid understanding of Japanese pop cultu...

More details: We need to have a simple made website landing page, where the landing page starts with a would you rather question (I will provide some examples later). Once the user has chosen an answer to the “would you rather” question, the websites will reveal itself (we will provide you with the background/landing photo page) In simplicity, what you need to provide us is a code where the website gets an interactive feature where the website user needs to choose a would you rather have “A” or “B” . Ideally there are at least 5-10 different “would you rather” questions so each time the user reloads the mane page, a would you rather question pops up. What type of multiple choice questions do you w...

...everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build ...

...everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build ...