FriTorial#56: Analyse Review in Google Sheets Using AI Formulas

Welcome to the FriTorial

Today in FriTorial🔥

• Explore the capabilities of n8n and see how advanced AI agents work

• Analyse Review in Google Sheets Using AI Formulas

• Contractor+ AI – Advanced Estimating & Project Automation for Modern Contractors

• AI-Generated Designs Are Now Approaching Figma Quality

• The Smartest AI Library on the Internet

• Halomate AI – The All-In-One AI Platform for Smarter Property & Hospitality Management

• Trending AI Tools

Explore the capabilities of n8n and see how advanced AI agents work

🚀 2-in-1 AI Masterclass on exclusive plug-n-play AI Agent : Inside the AI Lab

On Saturday, 29th November, 9 AM EST

Step into the future of automation!
In this exclusive session, you’ll learn n8n — the no-code workflow tool powering next-gen automations — and explore 12+ Advanced Plug n Play AI Agents built for real-world roles like Sales, Branding, Consulting, and Support.

💡 What you’ll see inside:
✅ How AI Agents automate business tasks in minutes
✅ How n8n connects tools, APIs, and data — no coding required
✅ Live demos of pre-built Plug n Play Agents ready to customize

🎯 Join and experience how businesses are scaling with AI.

Analyse Review or Anything in Google Sheets Using AI

Step 1: Open Google Sheets

Open your browser and navigate to create a new Google Sheet.

Step 2: Use AI Formula

Note: This is done in a Google Workspace business account.
Gemini AI formulas are business-use only, not for personal accounts.*

Process:

Start by opening Google Sheets using your business account.
In Column A, type “Reviews” in A1 and enter your review ideas in A2, A3, A4, and so on.

In Column B, add a header called “Sentiment”.
In cell B2, enter this formula to classify each review:

=AI("Classify this review as positive, negative, or neutral.", A2)

Drag the formula down to apply it to all review rows.

In Column C, add a header called “Summary”.
In C2, use this formula to generate a short summary:

=AI("Summarize this review in one short sentence.", A2)

Drag down to fill the column.

For detailed sentiment extraction, create three additional columns.

In Column D, use the header “Positive Points”.
In D2, use:

=AI("Extract only the positive points from this review.", A2)

Drag down to fill the column.

In Column E, use the header “Negative Points”.
In E2, use:

=AI("Extract only the negative points from this review.", A2)

Drag down to fill the column.

In Column F, use the header “Neutral Points”.
In F2, use:

=AI("Extract neutral or factual information from this review.", A2)

Drag each formula down so every review receives positive, negative, and neutral extractions.

Your final sheet layout will look like this:

| Reviews | Sentiment | Summary | Positive Points | Negative Points | Neutral Points |

All columns automatically fill using the AI formulas you entered.

Step 3: Final Output

The AI has processed all reviews and produced a full sentiment analysis, summary, and detailed breakdown of positive, negative, and neutral points.

This is my sample formula analysis.
You can use the same AI formulas to analyze any type of data in your own sheet.*

Get 95+ Tutorials like this

Contractor+ AI – Advanced Estimating & Project Automation for Modern Contractors

Contractor+ – AI-Enabled Estimating Software for Contractors & Field Services – Fast, Accurate, Business-Ready!

Contractor+ AI is a platform that allows contractors to create fast, accurate project estimates in minutes by simply describing the job in plain English—no spreadsheets or guesswork required.

Best Features:

• Natural: AI-Powered Estimating: Just tell Contractor+ what the job includes, and it instantly generates a detailed, professional estimate with materials, labor, pricing, and scope.

• Full Project Capabilities: Produces estimates, work orders, invoices, and proposals. Includes real-time material & labor pricing, client management, measurements, and job-cost tracking—all in one platform.

• Designed for Speed: Built to cut estimating and admin time from hours down to minutes while improving accuracy and helping you win more bids.

  Create Accurate Estimates in Minutes — Start Using Contractor+ AI Today!

AI-Generated Designs Are Now Approaching Figma Quality

The Smartest AI Library on the Internet🎉

Explore a world of 2789+ AI Resources from 97+ AI creators on LinkedIn, packed with actionable tutorials and diverse prompts!

Halomate AI – The All-In-One AI Platform for Smarter Property & Hospitality Management

Halomate AI – AI-Powered Automation Platform for Smarter Property & Hospitality Management – Fast, Unified, Effortless!

HaloMate AI is a platform that helps teams generate, manage, and optimize content effortlessly — just describe what you need in plain English, and watch it come to life.

Best Features:

• Natural: Simple Prompting — Tell HaloMate what content you need (blog posts, social media updates, ad copy, etc.), and the platform writes it for you automatically.

• Smart Templates & Customization: Use ready-made templates for different content types, or craft your own style guidelines so output stays consistent and on-brand.

• Collaboration & Workflow Tools: Assign tasks, leave comments, track progress, and manage review cycles — ideal for teams working together on content creation.

• Speed & Efficiency: Cuts down content creation time from hours to minutes, helping you maintain a steady output without burning time or resources.

Trending AI Tools

MediaPET Create professional video ads in under 5 minutes.

Feen Solve problems, summarize, write, and create study tools with AI.

DesignLumo Generate editable creatives with AI and post in minutes.

Macaly Turn words into working websites, instantly.

Avaturn Live Transform business interactions with lifelike AI avatars.

Legal Contract Review Prompts

Advanced Clause-by-Clause Contract Review

This prompt guides an AI through a full legal review of any contract, from initial summary to granular clause-by-clause analysis. It ensures risks, obligations, and compliance issues are identified with precision. Use it when you need a comprehensive, lawyer-style evaluation with clear recommendations.

You are an experienced contracts lawyer. Please review the attached contract by following the steps outlined below. Step 1: Do a preliminary review of the agreement before analyzing it. 1. Read and Summarize: Read the entire contract provided below before taking any steps. Then summarize the agreement’s purpose, parties involved, key obligations, and the term or duration of the contract. Identify any schedules, exhibits, or attachments that form part of the agreement. Identify any provisions that put obligations on the company to take some action by a certain date. 2. Identify Governing Law & Jurisdiction: Identify the governing law and jurisdiction clauses, if any. Summarize the implications of these clauses, particularly in regard to dispute resolution, enforcement, and interpretation under the specified legal regime. Step 2: Then perform a detailed clause-by-clause analysis. Break down the contract into its essential components and analyze each segment as follows: 1. Parties & Authority: Verify that all parties are correctly identified and have the legal authority to enter into the contract. Identify any references to subsidiaries, affiliates, or third-party beneficiaries and their implications. 2. Definitions & Interpretations: Review all defined terms and identify inconsistencies or ambiguities. Determine whether definitions are appropriately scoped to protect the client’s interests. 3. Scope of Work/Obligations: Outline the specific obligations of each party, including deliverables, performance standards, timelines, and milestones. Assess whether the obligations are clearly defined, measurable, and enforceable. 4. Payment Terms & Financial Clauses: Analyze all financial provisions, including payment terms, invoicing procedures, currency, late payment penalties, and taxes. Identify any unreasonable or ambiguous terms that may affect cash flow or create unintended financial liabilities. 5. Term, Termination & Renewal: Identify the contract’s duration, termination rights, and renewal provisions. Assess whether termination for convenience, termination for cause, and automatic renewal clauses are appropriate and aligned with the client’s interests. 6. Intellectual Property & Confidentiality: Evaluate intellectual property ownership, licensing, and usage rights. Review confidentiality obligations and determine whether they are adequately protective and reasonably limited in scope and duration. 7. Representations, Warranties & Covenants: List all representations, warranties, and covenants made by each party. Identify any broad or indefinite language that could create unforeseen liabilities or obligations. 8. Indemnification & Limitation of Liability: Examine indemnity provisions and identify their scope (e.g., third-party claims, negligence, breach of contract). Assess whether liability limitations are adequately tailored to protect the client’s interests. 9. Dispute Resolution: Identify the dispute resolution mechanism (e.g., arbitration, litigation, mediation). Evaluate whether the mechanism is appropriately tailored for the nature and value of the agreement. Suggest revisions. 10. Boilerplate Provisions: Review standard clauses such as force majeure, assignment, waiver, amendment, severability, and notice provisions. Confirm their compatibility with the client’s standard terms or preferred language. Step 3: Next, perform a risk assessment and set out recommendations. 1. Risk Identification: Identify any material risks or ambiguities within the contract that could result in potential liability, disputes, or financial loss. Categorize these risks by severity (e.g., high, medium, low). 2. Propose Revisions: Suggest specific, precise language amendments to address identified risks or ambiguities. Set forth the purpose and rationale for each proposed revision. Step 4: The review for compliance & alignment with company policies and applicable law. 1. Compliance Review: Evaluate whether the agreement complies with applicable laws, regulations, and internal company policies. Identify any clauses that could conflict with statutory or regulatory requirements. 2. Policy Alignment: Assess whether the contract aligns with the company’s strategic objectives, preferred contracting principles, and risk tolerance thresholds. Step 5: Prepare a summary. Prepare a comprehensive summary detailing your findings, proposed amendments, and overall assessment of the contract’s suitability. Structure the report as follows: * Executive Summary: High-level overview of key findings. * Risk Matrix: Categorization of risks by type and severity. * Suggested Amendments: Specific clauses to be revised with proposed language. * Final Recommendation: Approval, revision, or rejection. [Paste contract text here].

Balanced Indemnity and Liability Revision

This prompt supports focused legal review of indemnity, liability limits, termination rights, and exclusivity risks. It helps generate business-friendly explanations and improved clause language tailored to US commercial standards. Ideal for refining SaaS agreements, NDAs, and other contracts where balanced protections matter.

You are an experienced US-based in-house commercial lawyer. Review this contract (or clause) and identify risks related to indemnity, liability, termination, and exclusivity. Explain them in business-friendly language. Suggest a revised indemnity clause that is more balanced, limits our company’s exposure, and excludes indemnification for the other party’s negligence. Draft a limitation of liability clause for a SaaS agreement, capping liability at 12 months of fees paid and excluding indirect damages. Redline this NDA to ensure mutual protection, prohibit reverse engineering, and extend trade secret protection indefinitely. Write a contract clause that prohibits assignment without written consent and voids unauthorized transfers. [Paste contract or clause text here].

Demand Letter for Personal Injury

This prompt creates a structured, persuasive demand letter tailored to the injury type and state law. It incorporates liability analysis, damages calculations, and relevant statutes to support your claim. Use it to produce a polished letter that sets expectations, details losses, and invites timely settlement.

Draft a persuasive demand letter for a [type of personal injury case] in [state]. Include factual background, liability analysis, and damages demand, written in a professional but assertive tone. Ensure it references relevant statutes like [e.g., negligence laws in your state], outlines medical expenses, lost wages, and pain and suffering calculations, and proposes a settlement deadline of 30 days. End with a clear call to action for negotiation.

Feedback

Know someone who may be interested?