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.
Modern Tree of Life Logo Redesign Category: Branding, Creative Design, Design Optimization, Digital Art, Graphic Design, Illustration, Logo Design, Photoshop, Visual Design Budget: $10 - $30 USD
On-Page SEO for Traffic Growth Category: Analytics, Internet Marketing, Keyword Research, Link Building, Page Speed Optimization, SEO, Website Audit Budget: $30 - $250 NZD
01-Mar-2026 23:01 GMT
Minimum Sermaye, Maksimum Kazanç Planı Category: Business Analysis, Business Consulting, Business Development, Business Strategy, Data Analysis, Financial Analysis, Financial Planning, Market Research, Project Management, Risk Management Budget: $10 - $30 USD
01-Mar-2026 23:00 GMT
Traditional Wedding Ceremony Videography Category: A / V Design, A / V Editing, Cinematography, Film Production, Video Editing, Video Production, Video Services, Videography Budget: $30 - $250 USD
Advance Steel 3D Model Conversion Category: 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Rendering, Architectural Engineering, Architectural Rendering, AutoCAD, CAD / CAM Budget: €30 - €250 EUR