
GPT for Sheets Prompt Engineering
- or -
Post a project like this68
£50(approx. $67)
- Posted:
- Proposals: 13
- Remote
- #4452684
- Awarded
Web & AI , Full-Stack development| WordPress| Graphic Designing| Video Editing| Database| Mobile App| APIs
Full-Stack Web & Mobile App Developer With AI Integration & Automation Expertise
Full Stack Web & Mobile App Developer | Expert in Android & iOS |Graphic Design| Video Editing & Animation|Certified & Top Rated

AI Automation | CRM Specialist | System Integration Expert | Software Developer | Data Entry Specialist
PPH TOP Web Developer | Digital Marketing (SEO, Social Media Management, Facebook/Instagram Ads, Google Ads)|WordPress, Shopify, Wix, e-commerce, | Video Editing

Expert in Design, Marketing, Ghost writer and Business Social Media Marketing & Management Services
Responsive Websites, Membership Websites, Ecommerce, Bespoke Custom Solutions, C#, Angular, Python, Azure, ASP.net Core, Sql, CSS, HTML, Web development

Data Analyst | Excel & Power BI Expert| Automation| Data Entry | Virtual Assistant
MEP |Lighting | DIALux I Electrical I MATLAB I Solar|PCB I Firmware |Embedded
1298795512903820489978421951691982427122080737539391300758412275455219778123533085826915
Description
Experience Level: Entry
Using GPT for sheets. I need a prompt that allows the following... There are two sheets in the one spreadsheet. We're trying to match a company from the second sheet called Reference with a company in the first sheet called Email based on the companies' similarities as described in the corresponding row in column O of Email sheet and in column F of Reference sheet. The first sheet is called "Email" and the second sheet is called "Reference" - the output ie the chosen company needs to be input in the column P of the Email sheet. In both sheets the company name is in column A. Here’s a summary of the requirements: My Goal For each company in the "Email" sheet is to find the most similar company from the "Reference" sheet. Similarity is based on: "Email" sheet: column O and "Reference" sheet: column F. Output: Write the name of the most similar company from "Reference" into column P of the "Email" sheet, for each row.
Mitchel P.
100% (3)Projects Completed
5
Freelancers worked with
5
Projects awarded
80%
Last project
19 Dec 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Before I finalize the prompt, can you confirm one thing for me:
If two companies have very similar descriptions, do you want the formula to choose the closest match automatically, or should it flag those rows so you can review them manually? -

Where is your spreadsheet?
11441021144101
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies