Google apps script get sheet by name jobs

Hi! Your job 1. Go to a website (url in brief) every day to every other day 2. On that website click a link to open another website. This website is NOT live/active yet. 3. Open the list of names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the ...names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the email is sent, change body of email and when the scraping starts/stops as well as frequency (daily or every other day). You may NOT do manual entry You MUST build something that is automatic and can be edited by...

I'm in need of a mobile application for school buses, aiming to provide real-time GPS tracking for parents and enhance the overall bus tracking experience. Key Features: - **Real-Time GPS Tracking**: This feature is crucial. It should be able to accurately display the location of ...automaticly Ideal Skills: - Proficiency in mobile app development for both iOS and Android platforms. - Prior experience with GPS tracking applications. - Knowledge of integrating real-time tracking systems. - UI/UX design experience to ensure the app is user-friendly and engaging. - Strong communication skills to ensure parents are kept informed and up-to-date. If you have experience building similar apps or have the skills to deliver the required functionalities, I'm looking forward to he...

Looking for an experienced Google Ads campaign manager to leverage my website's existing Ads account. The primary goal of the campaign will be to increase website traffic Ideal candidate must have: - Extensive experience in effectively running Google Ads campaigns - Proven track record of increasing website traffic - Strong understanding of marketing strategies for engaging young adults (18-25 population segment) - Outstanding analytical skills to interpret AdWords data and make necessary adjustments for optimal results. I welcome your expertise and suggestions on how to achieve the desired goals.

I'm seeking the expertise of a creative professional to revamp my existing PowerPoint presentations into engaging Google Slides designed specifically for high school students. Key Tasks: - Conversion of current slides into Google Slides. - Enhancement of slides aesthetics with vibrant colors. - Incorporation of infographics and images relevant to the subject matter. - Retention of original content while transforming the text layout for better readability and impact. Ideal Candidate: - Proficient in Google Slides - Experience in Graphic Design. - Ability to create engaging infographics - Experience in educational content is a plus. The focus of this project is to improve the design and visual appeal of the slides without altering the essential details. Needs...

As an online retailer, I'm seeking an Android app specialist who can create an interactive application for my WooCommerce WordPress site, w...Key deliverables: - An interactive shopping app without a pre-defined design (will require your expertise) - Seamless social login integration - Securely integrated PayPal as our payment gateway Ideal freelancer would have: - Extensive experience in Android app development, specifically for WooCommerce/WordPress sites - Proven track record in creating secure, intuitive and user-friendly shopping apps - Expertise in social login and PayPal integration - Strong design acumen to help guide the visual aspects of the app. Your expert suggestions and professional input will be appreciated to make the application more customer-friendly and ea...

...seeking an experienced web developer with a strong background in PHP and CakePHP 2.x framework to integrate Google Sign-In into our existing web application. Our application currently follows a multi-step flow and uses MVC architecture. The integration must be seamless and maintain the current workflow. Objectives: Google Sign-In Integration: Implement Google Sign-In to allow users to authenticate using their Google accounts. User Redirects: After successful authentication, users should be redirected to the 'typeform11' page as part of our existing workflow. User Data Retrieval: Retrieve and display the user's Google account information including profile picture, email address, and name on the redirected page. Error Handling: Pro...

I'm seeking a qualified developer to create a mockup for a psychology-focused iOS app. For this project, the key requirements are: Primarily, I need someone who can deliver this mockup as soon as possible. Please detail your process, timeline, and how you approach user authentication in your bid. Expertise in design for psychology or wellness apps would be beneficial. I would provide all the art and graphic design materials I need and I could use it in every part of the process in figma, I just need a fairly animated prototype and an intuitive user interface

I'm seeking an experienced animator to help me create a short, less than 1-minute, black and white animated sketch drawing video for my script. I need someone who can use AI generated sketch tools to create sketches (simple grey tones) being drawn as a narration plays Key Requirements: - Video Length: Less than 1 minute - Animation Style: Black and white - Script: I will provide a complete script for the video Ideal Skills and Experience: - Proficiency in sketch drawing animation - Previous experience with black and white animation - Ability to work with provided scripts Please showcase relevant previous work in your proposal.

I'm seeking an experienced digital marketer for a Google Ad campaign targeting parents of K-12 students and students in 10th to 12th standard. The sole goal of this project is to enhance online sales and lead conversions. Task Breakdown: - Build a strategic campaign focusing on our target audience - Analyze and optimize ads periodically for improved outcomes Budget: Please note that project budget is $100-$500 Required Qualifications: - Proven track record in managing and optimizing Google Ad campaigns - Familiarity with the education system and the ability to attract parents of K-12 students as well as students reaching graduation - Experience in Google Ads resulting in increased online sales and conversions.

I'm looking for an expert in Google Cloud and AWS to help me migrate my existing WordPress site. The current site is hosted on Google Cloud Platform and I'm aiming to improve its performance by migrating it to AWS. Key Requirements: - Migrate WordPress site from Google Cloud to AWS - Focus on performance improvement Specific Services Needed: - Help calculating the cost of Cloud Ideal Skills/Experience: - Expertise in Google Cloud and AWS - Proven experience with WordPress migrations - Understanding and ability to optimize for performance - Experience with calculating AWS service costs

Hi! Your job 1. Go to a website (url in brief) every day to every other day 2. On that website click a link to open another website. This website is NOT live/active yet. 3. Open the list of names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the email is sent, change body of email and when the scraping starts/stops as well as frequency (daily or every other day).

I'm in need of an experienced developer to create a comprehensive financial website and mobile apps. Key Features: - User registration and authentication - Listing and search functionality - Messaging system End-User Functions: - Facilitating car sales between individuals - Handling service requests between individuals - Managing financial transactions between companies Mobile Apps: - Required for both iOS and Android platforms Ideal candidates should have proven experience in developing similar financial platforms and apps. A good understanding of user-friendly design, secure transaction processing, and multi-platform development is essential.

To ensure ongoing productivity within my operations, I'm in need of a talented Python programmer who can masterfully create a script specifically for a Topaz Signature Pad. The project will require the following: - Designing and implementing a script that can capture signatures - Creating an interface able to display these signatures on a screen, optimally in an image format - Developing a functionality that will save these captured (see next dot) signatures to a file. The file type is flexible; PDF, JPEG, PNG would all be acceptable. - Capture signatures from the Topaz T-LKB755SE-BHSB-R SignatureGem LCD 4x3. -Simple gui with 2 buttons, start siging and save image. Image then shown in gui and saved in database. Your experience should demonstrate: - Proven Python progr...

**Project Overview:** We're looking to set up a Zoho Portal that allows users to create emails using their custom domain and integrate them with Zoho Sheets. The goal is to replicate the functionality of an existing Google Apps Script that forwards emails to Google Sheets. The freelancer will be responsible for configuring the Zoho Portal, setting up email forwarding, and integrating Zoho Sheets to achieve seamless email-to-sheet automation. **Prerequisites:** - Access to Zoho Mail and Zoho Sheet. - A custom domain configured with Zoho Mail. - Basic knowledge of Zoho Mail, Zoho Sheet, and email forwarding. **Scope of Work:** 1. **Zoho Portal Setup:** - Configure the Zoho Portal to enable email creation using the custom domain. ...

...my personal use, so the target audience is just me. The purpose behind this app is to enhance my productivity by enabling me to work on different tasks simultaneously with the added advantage of using the camera function when needed. Key features and requirements: - Split-screen multitasking functionality - Full access to the iPad's camera within the app - User-friendly interface for easy navigation and task switching - Seamless integration with other iPad apps for a comprehensive multitasking experience Ideal skills and experience for this project: - Proficient in iPad app development, especially with multitasking features - Strong knowledge of camera integration within iOS apps - Experience in creating user-centric interfaces for optimal user experience - ...

I am seeking an expert in Google Display Ads to help me drive traffic to my apparel website, targeting professionals aged 25-65. The primary goal of the traffic generated should be to increase sales. Key requirements include: - Proficient in Google Display Ads: You should have a proven track record of setting up and managing these ads effectively. - Understanding of Audience Targeting: Experience in targeting specific demographics, in this case professionals aged 25-65 - Conversion Optimization: You should be able to optimize the ad campaign to make sure the traffic generated translates into actual sales.

I'm seeking an outstanding marketing expert who can assist me in growing my WhatsApp group targeted at foreigners living in the UK. This group serves as a platform for networking and possibly, an avenue for language exchange and sharing travel tips. Ideal candidates should possess: - Proven success in social media outreach and word-of-mouth marketing. - Ability to create an engaging and diverse campaign. Responsibilities: - Promote the WhatsApp group through strategic social media outreach and word-of-mouth strategies. - Track group growth and engagement. Note: Details of the group content remains undefined but should ideally attract the target audience. As such, I'm open to discuss these details with the ideal candidate. Experience working with this demographic is a plus....

I'm seeking an outstanding marketing expert who can assist me in growing my WhatsApp group targeted at foreigners living in the UK. This group serves as a platform for networking and possibly, an avenue for language exchange and sharing travel tips. Ideal candidates should possess: - Proven success in social media outreach and word-of-mouth marketing. - Ability to create an engaging and diverse campaign. Responsibilities: - Promote the WhatsApp group through strategic social media outreach and word-of-mouth strategies. - Track group growth and engagement. Note: Details of the group content remains undefined but should ideally attract the target audience. As such, I'm open to discuss these details with the ideal candidate. Experience working with this demographic is a plus....

I'm experiencing an urgent situation with my Google business account. Every time I try to upload product images, they are being rejected by Google but I'm not receiving any specific reason or error message. I need help to resolve this issue immediately. Ideal skills and experience for this job include: - Experience working with Google business profiles and photo uploading - Familiarity with common issues related to image rejections - Ability to troubleshoot and resolve technical issues quickly and efficiently I would appreciate it if this could be resolved as soon as possible. Thank you.

I'm seeking a skilled developer to create an interactive and realistic conversational avatar for my iOS, Android, and Web-based app. The avatar will be trained on user-provided data and require a high level of aesthetic and realistic appearance, lip synchronization, and believable facial expressions. Key requirements include: - Multi-platform app development: You should have experience creating apps that are compatible with iOS, Android, and web-based platforms. - AI Avatar Development: A proven track record in designing and implementing interactive and realistic conversational avatars. - Data Training: The ability to incorporate user-provided data, such as text-based conversations, audio recordings, and video recordings, into the avatar's training process. An ideal can...

I'm looking for a skilled AI engineer with experience in finance, proficient in Python, TensorFlow, and PyTorch. Key Responsibilities: - Design and implement machine learning algorithms to analyze financial data - Develop natural language processing models to process and interpret financial texts - Implement computer vision techniques for data visualization and pattern recognition Ideal Skills: - Proficiency in Python, TensorFlow, and PyTorch is a must - Experience in the finance industry is a plus - Strong understanding of machine learning, NLP, and computer vision techniques - Ability to work with diverse and complex datasets If you're a proactive AI engineer with a keen interest in finance and a proven track record of implementing AI solutions, I'd love to discuss this...

I'm looking for a WordPress expert who can improve the performance of my website ...who can improve the performance of my website through code cleaning and optimization. Your work will not only involve identifying and fixing issues but also ensuring that the website runs smoothly and efficiently. The end goal is to have a clean, fast, and effective WordPress site. I will give my home page and rearrange the coding to make the page as fast as possible. The fastest AND best script will get the project. If you AND we enjoy working with you, you will be paid you 1500$ more to do the same for the whole website. Ideal candidate for this job would have: - Proficiency in WordPress - Solid experience in website performance optimization - Expertise in mobile optimization and re...

...Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown in the renew breakdown This is not just putting data but understanding all financial Projection and profit loss - so will make sense this is projections for company for 2024, 2025, and 2026 We need it in 4 days from now you have to fill up all areas and Spread sheet tabs in the Financial Plan Spreadsheet Thanks! See attached Full Zip Specs ...

I'm seeking an Apple Script expert to help me automate a specific task in Numbers. - The task involves splitting a single column of four-digit numbers into four separate one-digit columns. - The split should be done in a sequential order, meaning the first digit of each number will go into the first separate column, the second digit into the second separate column, and so on. Ideal Skills and Experience: - Proficient in Apple Script - Extensive experience in automating tasks within Numbers - Strong understanding of data manipulation and processing

I'm seeking a proficient developer to build an extensive real estate app compatible with iOS, Android, and Web-based platforms. Key Features: - Property Search: advanced filter mechanis...reference. - Live Call: An integrated feature for live-call discussions with property owners or agents. Additional Functionalities: - User Registration and Login: A secure user registration and login functionality is pivotal. - Location-Based Search: The app should have the capacity for location-based property searches. Ideal Candidate: You should have experience in developing real estate apps, and possess a good understanding of property search algorithms and user-friendly design. Strong skills in cross-platform app development and a comprehensive portfolio demonstrating these skills...

...easily browse, select and purchase products. - Cryptocurrency is the preferred payment method, so the developer should have experience in integrating this for both the app and website. - User accounts with login functionality are essential. Users should be able to create profiles and have a personalized shopping experience. Ideal Skills and Experience: - Proven experience in developing e-commerce apps and websites. Please provide examples of previous work. - Proficiency in integrating cryptocurrency payment gateways. - Strong understanding of user account systems and the ability to create a smooth, user-friendly interface. - Experience in developing for both Android and iOS, ensuring a consistent experience across platforms. If you're confident in your ability to deliver a...

I am looking for an expert in Google Ads to help set up ADX MA ads for my project. The primary objective of these ads is for AD MANAGER. Specifically, I'm in need of help when it comes to implementing ad tags on my website. Your skills and experience should encompass: - Proficiency in Google Ads platform - Understanding of ADX MA and its application - Experience in ad tag implementation - Knowledge in Display Ads, Search Ads, and Video Ads strategy I am aiming for a smooth, effective project execution. As such, I need someone focused, detail-oriented, and experienced in the field. Reach out if you believe you're the perfect fit.

I am in need of a skilled accountant to help with the preparation of my financial statements. The ideal candidate will have experience with Xero. Key requirements of the project include: - Preparation of Income Statement, Balance Sheet, and Cash Flow Statement - Proficiency with Xero accounting software Please note, the successful applicant should have a strong background in accounting, with prior experience in financial statement preparation being highly valued.

its says site compromised and dissapproved. I have scanned the site and its fine. You have to work on any desk

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

I need someone to post jobs for me on indeed and reply and orginziae replys into google sheet

I require a dedicated Flutter Developer to work part time on the development of an e-commerce platform. You'll be focused on three core features: - Develope app working with woocommerce plateform - Have professional experience with php, javascript, css - Have a professional experience with e- commerce apps and platforms Our e-commerce platform requires integration with payment gateways, hence, experience with such integrations is essential for this role. The ideal candidate will have experience in Flutter development, specifically with e-commerce functionality and payment gateway integration. Your ability to commit part time on a monthly salary basis will be advantages. Looking forward to a fruitful collaboration.

I'm seeking a professional PHP expert to assist with my current project. Key Responsibilities: - Hands-on PHP web development - PHP script optimization - Integration of PHP frameworks - Debug and troubleshoot code I'm looking for an individual with a solid understanding of PHP, who can help take my project to the next level. Your ability to optimize scripts, integrate PHP frameworks, and tackle web development issues will be crucial. Please provide examples of your past projects, particularly those related to PHP development. Experience and knowledge of PHP frameworks are a bonus. If you're a skilled PHP developer and you're ready to tackle new challenges, I'd love to hear from you.

...need of an experienced Apple developer to upload my fully developed iOS application in the Education category. Key Requirements: - I have a fully completed iOS app ready for upload. This is not a prototype or a project in its early stages. - Your primary task is to get my application on the Apple store, ensuring that all the necessary guidelines are adhered to. - The app falls under the Education category, so experience in this area would be a plus. Ideal Skills and Experience: - Extensive experience in uploading iOS apps to the Apple store. - A strong understanding of Apple's guidelines and requirements for app submission is crucial. - Experience in the Education category would be beneficial, but not mandatory. Please provide any previous work or relevant expe...

We need a web-based or desktop tool that allows us to upload third-party APKs and Firebase configurations. The tool should automatically modify the APKs to include notification and tra...and monitoring of app usage via our Firebase account once the app is installed on any mobile device. Functionality: Upload APKs and Firebase configurations through an intuitive user interface. Modify the APKs to include code that enables notifications from our Firebase account. Incorporate tracking code to monitor APK usage Compatibility: The tool should work with all types of APKs, including apps and games. User Interface: Provide a clear and user-friendly interface for uploading and managing APKs and Firebase configurations. Display relevant information and logs to the user during and after mod...

I'm looking for a weekly editable check-in sheet for my fitness clients, to be created in Google Sheets. - The sheet should contain sections for clients' names, contact information, weight, body measurements, workout details, and progress. - Each client should have a separate sheet, making it easier to manage and update the data. - The sheet should include formulas for tracking workout improvements, such as increased weights or reps. - Each sheet should be able to be progressed for approximately 8 to 10 weeks and should be editable week to week. - Ideally this sheet would be a template that I can use over and over again with clients. The ideal candidate for this job should have: - A good understanding of fitness tracking - P...

We operate a Google Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. The documents created all appear here: Then deploy the working code to the Original spreadsheet. All bids are final

I'm in need of a skilled graphic designer to help me modify my existing business logo. I am currently looking to change the name within the logo to align with our rebranding strategy. This new name will also be used for our second company, which shares the same graphics. Key aspects of the project include: - Updating the existing design: You will be required to keep the current design elements intact while changing the company name. - Ensuring brand consistency: It is important that the new name fits seamlessly into the existing logo and maintains the brand identity. Ideal candidate for this project should have: - Proficiency in graphic design software - Experience in logo design and branding - Strong attention to detail - Ability to understand and impl...

I need a simple app developed using Microsoft Power Apps. This app will primarily serve as a data entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to a...

I am seeking a skilled Laravel developer to build a live notification system with multichannel support – Email, Push, and SMS notifications. Key Functionalities: - The script should trigger notifications whenever a new message from the administrator is sent. - The appearance of these live notifications should be through a notification sound. Ideal Skills: - Laravel Development - Experience in developing notification systems. - Familiarity with Email, Push, and SMS notification integration. This requires a comprehensive understanding of Laravel and system notification integrations. Proven experience in a similar project will be a strong advantage.

...troubleshoot the conversion tracking on my Google Ads. I have successfully set up tracking for my lead submission conversions, managed through a Forminator form, but it seems to have stopped working after the initial recording. Key tasks and requirements: - Analyze the current GTM setup to identify the root cause of the issue. - Reconfigure GTM as needed to ensure accurate and consistent conversion tracking. - Test the tracking to verify that it's accurately recording the conversions. - Provide insights and recommendations on how to maintain and troubleshoot the tracking in the future. It's crucial for me to get this fixed as soon as possible, so please only reach out if you're experienced in GTM and have a proven track record of solving similar issues wi...

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

In search of a seasoned app developer who can design and develop sophisticated mobile applications for both iOS and Android platforms. I am looking for: - Expertise in generating a modern, clean look for the app - Proven track record developing apps with integrated e-commerce functionality Your skills and experience should ideally encompass: - Strong background in both iOS and Android development - Proficiency in creating stylish, modern app designs - Extensive experience in incorporating e-commerce features in apps - Conducting thorough testing and debugging to ensure optimal performance and user experience. - Good understanding of user-oriented design principles - Ability to work independently and manage your own schedule effectively - Attention to detail and a commit...

I'm seeking a skilled developer with Drupal experience to enhance the functionality of the Node by Email module. The specific improvements required are: Original Function - collect emails from a specific sender email account and post them as Article nodes authored by the specific sender user account. Modified Function - collect emails from ALL senders and post them as Article nodes authored by the sender user account. If an email sender email address is not associated with an existing user account, then create a user account with the user name and email address set to the sender email address. The password should be set to a random number. The account create date will be the current date. If you have any question about the work please let me know bef...

I'm looking for an experienced digital marketer who can strategize and execute a Google campaign. Key Objectives: - Increasing website traffic - Generating leads - Increasing brand awareness Target Audience: - Location-based, so expertise in geo-targeting is a must. Ideal skills and experience: - Proficiency in Google Ads - Extensive experience in campaign strategies - Proven track record in achieving website traffic, lead generation, and brand awareness goals - Expertise in location-based advertising.

Develop a Splunk App that integrates with the my API to scan URLs for scam activities and display the resulting scam scores (ranging from 0 to 100) within Splunk. The plugin will enhance cybersecurity measures by providing real-time alerts and insights based on the scam score data. Key Deliverables API Integration: Securely integrate the my API to fetch scam scores for URLs processed within Splunk. Custom SPL Command: Implement a custom SPL command that allows users to invoke the my API directly from the Splunk search bar. Interactive Dashboards: Develop interactive Splunk dashboards that display scam scores and relevant analysis. Configuration Interface: Create a simple UI within Splunk for configuring the plugin settings, such as API keys and alert thresholds. Automated Alerts: S...

...data from LinkedIn and Google, resulting in a thorough Google Doc. This task involves gathering the following specifics: Contact details, Company information, and Job titles. It also includes the LinkedIn Profile URLs of the relevant associates. The final document should contain around 100 to 500 entries. Ideal candidates possess conversance with LinkedIn's platform, effective Google search strategies, and proficiency in Google Docs. Excellent organization skills are also expected. Your meticulousness will help in ensuring that accurate, updated data are reported. Let your attention to detail shine through and exceed expectations in this task. I will give you a URL that contains approximately 50 records that have Organization Name, City, State...

I'm in need of a talented mo...should have all the necessary functionalities and interactions that are expected from a location-based app. Other Key Information: - The app will not require user authentication. It should be easily accessible and usable without the need for users to create an account or log in. Ideal Skills and Experience: - Proficiency in creating cross-platform mobile apps, with a focus on Maps and Location services. - Experience with developing apps that do not require user authentication. - Familiarity with integrating external services and APIs, particularly maps and location services. If you believe you have the necessary skills and experience to bring this project to life, please provide examples of your previous work and a detailed proposal ou...

I am seeking app developers who can create a social networking application for both iOS and Android platforms. The main features of this app...integration. Key Requirements: - Development of a social networking app for both iOS and Android platforms. - Incorporation of User profiles, Messaging, News feed, and web integration. - The app needs to be user-friendly, visually appealing, and highly engaging. Ideal Skills and Experience: - Proficiency in app development for both iOS and Android. - Past experience in creating social networking apps. - Strong understanding of User profiles, Messaging, and News feed functionalities. - Ability to integrate a web component into the app. If you have the skills and experience I'm searching for and can deliver quality, please feel free to ...

Google Ads advertiser required to run specific ads as agency