Remember when you started your business and kept all your customer information in your head? Then maybe graduated to random notes on your phone, followed by that one spreadsheet that somehow turned into fifteen spreadsheets? Yeah, we’ve all been there.

Today, I’m going to show you how to create a professional-grade Customer Relationship Management (CRM) system using just Google Sheets and Gemini. The best part? It takes less time to set up than ordering lunch.

Why This Matters for Your Business

If you’re running a business solo, you’re probably wearing all the hats – CEO, sales team, customer service, and coffee maker. You might think you don’t need a CRM yet, or that the fancy ones like Hubspot are overkill (and expensive!). But here’s the thing: organizing your customer information early is like laying the foundation for a house. Sure, you could build directly on the ground, but you’ll probably regret it later.

This solution is perfect if you:

• Want to stop losing track of important customer details
• Need to organize your business but don’t have time for complex software
• Are planning to automate things eventually (hello, Zapier!)
• Would rather spend your money on growing your business than on expensive software

What You’ll Need (Spoiler: Not Much)

• A Google Account (which you probably already have)
• Access to Gemini (the premium add-on on Google Workspace)
• Basic Google Sheets knowledge (if you can use a spreadsheet, you’re good)

Learn more about using Gemini across all Google Workspace tools in my guide!

The Secret Sauce: Understanding Gemini in Google Sheets

Before we get started, let’s talk about what Gemini can and can’t do. Think of Gemini as your helpful but slightly rigid assistant. It’s great at creating new tables from scratch, but once it’s done, it’s done – you can’t ask it to edit existing tables. It’s like working with a painter who creates amazing artwork but can’t touch up their paintings after they’re finished (yet).

Building Your CRM: The Step-by-Step Guide

Step 1: Creating Your Basic Structure

1. Open a new Google Sheet
2. Name your Sheet
3. Place your cursor in cell A1. 
4. Activate Gemini in the header menu next to your profile picture.
5. Here’s the magic prompt to use (feel free to copy and paste):

Prompt: “ Create a Google Sheet structured as a basic CRM to include the following columns:

• Contact ID 
• Full Name
• Email Address
• Phone Number
• Company Name
• Industry
• Lead Source 
• Status 
• Notes 
• Last Contacted 
• Next Follow-Up 
• Assigned To 
• Priority 
• Revenue Potential 
• Tags”

6. With your cursor in cell A1 – Click to insert the table. 

When you give Gemini this prompt, it doesn’t just create empty columns – it actually thinks through how a CRM should function and builds in smart features automatically. The table it generates comes pre-loaded with thoughtful data validation rules that make your CRM more professional and easier to use right from the start!

The tweaking required is minimal! Just tailor the industry options specific to your business or adjusting the color coding to match your preferences. But the heavy lifting is already done for you through a single well-crafted, prompt.

Making It Look Professional (The Devil’s in the Details)

After you click that “Insert” button and your table appears, you’ll notice the header row looks a bit… cramped. Let’s fix that to make it easier on the eyes and more functional. Think of this like organizing your desk – everything needs its proper space to be useful.

Step 1: Format Your Header Row

1. Click and drag to select the entire first row (your header row). Or hold the Shift key down and select each column one at a time.
2. Right-click and select “Resize row”

3. Set the height to about 100 pixels to give your headers room to breathe

Now for the text wrapping step that makes everything readable:

1. With your header row still selected, look for the text alignment button in your toolbar
2. Click the small arrow next to it to see three options
3. Choose the middle icon that shows text with lines stacking evenly (this is called “Clip/Wrap”)
4. Your text will now neatly center itself vertically in the cells

This vertical centering is like giving each word its own perfect spot in the cell – not squeezed at the top or bottom, but floating right in the middle where it’s easy to read.

Step 2: Adjust Column Widths

Now let’s make sure each column has enough room for its content. Think of this like adjusting shelves to fit different sized books:

1. Hover your mouse between column headers until you see the resize arrow (like between A and B)
2. Double-click to auto-fit the column to its content, or
3. Click and drag to manually adjust each column width

Time-saving tip: Want to adjust multiple columns to the same width? Hold Shift while selecting them, then adjust once to change them all together.

Adding Smart Features

Step 3: Set Up Data Validation

This is where we add guardrails to keep your data clean and consistent. Think of it as creating a multiple-choice test instead of asking for essay answers – it’s easier to keep track of and analyze later.

When working with columns like Industry, Status, and Priority and Tags, you’ll want to create standardized options. Let’s start with the Industry column as an example:

1. Click on the Industry column
2. Go to Data → Data validation. This will open up the validation rules side panel.
3. Click “Add rule”
4. Under “Criteria,” select “Dropdown”
5. Enter your industry options one at a time. For each option:
   • Click the dots icon to add a new item
   • Type in your option (like “Technology”)
   • Click the color circle next to it to assign a color
   • Choose a color that makes sense for that industry
   • Repeat for each industry (Healthcare, Finance, etc.)

6. Click “Done” to save your validation rule 

Repeat this process for other columns that need specific options:

Setting Up Status Tags

In your Status column, add these validation options with color coding:

• New Lead
• Contacted
• Qualified
• Customer
• Not Interested

Setting Up Priority Levels

For the Priority column, set up these validation options:

• High
• Medium
• Low
• N/A

Setting Up Tags

The Tags column deserves special attention, as it helps categorize your contacts with these important labels:

• VIP
• Repeat Client
• New Lead
• Inactive
• High Potential

Think of these tags like sticky notes you might put on a physical file folder – they give you instant visual cues about who you’re dealing with and what level of attention they need. The color coding makes it even easier to quickly scan your CRM and spot your most important contacts or urgent follow-ups.

For example, you might tag a long-term client who regularly brings in business as both “VIP” and “Repeat Client,” while a promising new contact might get tagged as “High Potential” until they convert to a customer.

The color-coded dropdown system not only keeps your data consistent but also makes it visually easy to scan your CRM and spot patterns. No more wondering if you typed “Finance” or “Financial” – you’ll have one standard option for each choice.

Preparing for Growth: The Zapier Connection

Here’s where thinking ahead pays off. By setting up your CRM this way, you’re building it to play nice with automation tools like Zapier. Later, you could automatically:

• Add new leads from your website
• Send follow-up emails
• Create tasks in your todo list
• Update customer status based on actions

Pro Tips from the Trenches

• Keep one row of sample data as your template
• Use consistent formatting for dates (trust me on this one)
• Don’t go crazy with too many options in your dropdowns
• Back up your sheet regularly (because Murphy’s Law is real)

What’s Next? Let Data Guide Your Growth

The real power of starting with a simple CRM is that it positions you perfectly for smart automation. But before you dive head first into automating everything in sight, there’s a crucial step that many solopreneurs skip: understanding where your time actually goes.

I used Trello a time tracking tool, to monitor my activities for 14 months. The results were, humbling…. to say the least. I learned I was spending a crazy amount of time on administrative tasks -inbox management, searching for files, and appointment scheduling. These weren’t just minor time sucks; they were gaping holes in my productivity.

This insight led me to focus my automation efforts where they’d have the biggest impact. Through strategic automation, I’ve managed to:

• Reduce administrative time by 40%
• Cut client onboarding time by 60%
• Streamline content creation, saving another 60%

But here’s the thing – your time audit might tell a completely different story. Maybe you’re spending too much time on proposal writing, or perhaps social media management is eating up your productive hours. Every solopreneur’s inefficiencies are as unique as their business.

Pro tIp: Tracking my time in Trello was cumbersome (but worth it). I recommend giving RescueTime a try. It works passively ie: no need for manual data entry.

Starting Your Time Audit

You don’t need to track for 14 months like I did. Even a month of honest tracking can reveal patterns that will surprise you. Consider tracking:

• Client communication time
• Administrative tasks
• Content creation
• Sales activities
• Planning and strategy time

Once you have this data, you can start identifying which tasks in your CRM could be automated. For instance, if you notice you’re spending hours copying client information from emails into your CRM, that’s a prime candidate for a Zapier automation that could do it automatically.

The beauty of starting with this simple Google Sheets CRM is that it’s ready to grow with you. As you identify your specific time drains, you can gradually add automations that make sense for your workflow. It’s like having a custom-built efficiency machine that evolves based on your actual needs, not someone else’s idea of what you should be doing.

Remember, the goal isn’t to automate everything – it’s to automate the right things. Let your time tracking data be your guide to what those “right things” are for your unique business.

Need a Shortcut? I’ve Got You Covered!

I know that creating a CRM from scratch can feel overwhelming, even with step-by-step instructions. Sometimes you just want to get started without reinventing the wheel. That’s why I’m sharing my own template with you.

Take a look at what you’ll be building:

Like what you see? You can have this exact setup in less than 5 minutes:

1. Click here to access my CRM template.
2. Make a copy for yourself (File → Make a copy)
3. Start customizing it for your business

The template comes with all the data validation rules, color coding, and formatting already set up. It’s like moving into a fully furnished apartment – everything’s ready to go, you just need to make it your own. Your welcome. 😊

Getting Started

Your solo business just got a whole lot smarter! Whether you build this CRM from scratch using the tutorial above or start with my template, the key is to begin using it in your daily workflow. Start simple by adding your current contacts and gradually explore its features while you track where your time goes. Remember – you can’t improve what you don’t measure.

Wondering How This CRM Could Evolve With Your Specific Business?

Book a free Discovery Call, and let’s map out your personalized CRM and automation strategy. Together, we’ll identify where you’re losing time in your customer management process and build a system that works as hard as you do.

[Book Your Free CRM Strategy Session]

The post The 30-Minute CRM: How to Use Gemini and Google Sheets to Organize Your Business appeared first on Supernova Media.

Ever had one of those moments when you’re in the zone, drafting the perfect email to a client, and suddenly need to reference last month’s project proposal? The old you would have opened a new tab, navigated to Drive, searched through folders, and… wait, what were you writing about again? That flow state? Gone.

Enter Gemini in Google Workspace – think of it as having a brilliant assistant who’s read every single document in your digital office and remembers everything. It’s the bridge that connects all your Google Workspace apps through a convenient side panel. Whether you’re in Gmail, Docs, Sheets, Slides, or Drive, Gemini brings relevant information to you, right where you’re working.

Not sure if Google Workspace is the right fit for your solo business? Check out my guide to help you decide: “Is Google Workspace Right for Your Solo Business? A Solopreneur’s Guide“.

The Side Panel Revolution: Your Digital Filing Cabinet Gets Smart

Think of Gemini’s side panel as that super-efficient assistant who knows exactly where everything is in your digital office. It’s right there, quietly sitting on the right side of the tools you use every day – ready to spring into action whenever you need it. No more endless tab switching or playing detective with your file search.

Gemini in Gmail: The Inbox Whisperer

Managing emails can feel like wrestling an octopus. Gemini simplifies this by summarizing email threads, drafting replies, and suggesting calendar events or follow-ups. Plus, it can reference Drive files directly from the side panel, so you’re never left scrambling for attachments mid-email.

• Find and Reference Information: Easily locate Drive files or email threads directly from Gmail’s side panel.
• Summarize Email Threads: Get the gist of long email chains without reading every word.
• Create Draft Emails: Gemini can craft responses that hit the right tone and content.
• Suggest Responses: Quick, AI-generated replies save time for frequently asked questions.
• Calendar Information Integration: Need to check your schedule or suggest meeting times? It pulls data from Google Calendar.

Google Docs: Your Collaborative Writing Partner

Writer’s block? Not on Gemini’s watch. Writing proposals or reports gets a whole new dimension with Gemini. It can help brainstorm ideas, suggest improvements, and even help structure your document. The best part? It can reference your existing Drive documents for consistency in tone and content. Working on a client proposal? Gemini can pull relevant information from your previous successful proposals stored in Drive.

• “Help Me Write” Tool: Draft anything from reports to proposals with AI-generated suggestions.
• Refine Content: Tighten up grammar, tone, or structure with one click.
• Summarize Drive Files and Gmail Emails: Pull in relevant summaries directly into your document.
• Creative Idea Generator: Struggling with ideas? Gemini has your back.
• Create Images: Add visuals to your documents without needing a separate tool.

Google Sheets: Data Analysis Made Human

Gone are the days of manually building complex spreadsheets from scratch. For solopreneurs who aren’t spreadsheet wizards, Gemini acts as your data interpreter. With a knack for summarizing data and providing insights, it can spot trends or help you organize data faster. Need to compare figures or reference a budget file in Drive? The side panel integration lets you pull data without breaking focus.

• Build polished, formatted tables and visualizations in seconds.
• Generate formulas and insights without needing advanced spreadsheet skills.
• Pull relevant summaries from Drive and Gmail for added context.

Google Slides: Presentations That Pop

Presentations often require toggling between research, visuals, and layouts. Gemini saves the day by assisting with creative ideas, content refinement, and even generating images. It can also pull relevant data or files from Drive to make your slides shine. It’s like having a designer, researcher, and copywriter rolled into one tool.

• Content Refinement: Improve your slide copy to make it engaging and impactful.
• Creative Ideas: Get suggestions for layout, tone, and visuals.
• Generate Images: Create custom images to enhance your slides.
• Drive Integration: Seamlessly pull in charts, images, or data from your Drive.

Google Drive: Your Digital Brain Gets an Upgrade

Let’s face it: Drive can sometimes feel like a black hole where files go to disappear. This is where Gemini truly shines. Imagine having an assistant who has read every single document in your Drive and can instantly connect relevant information across all your files. Need to find that one specific detail from a meeting note you wrote months ago? Gemini can locate it and provide context from related documents.

• Find and Reference Files: Search and reference files from Gmail, Docs, or Slides.
• Contextual Suggestions: Get file recommendations based on your current tasks.

Google Meet: Professional Virtual Presence

Gemini elevates your virtual meetings with studio-quality features and smart note-taking. Custom backgrounds, enhanced lighting, and clear audio help you maintain a professional presence, while real-time translations break down language barriers.

• Providing studio-quality visuals, lighting, and sound.
• Capturing notes and action items automatically.
• Offering translated captions for seamless multilingual collaboration.
• Enabling custom backgrounds to keep your setup professional.

Google Chat: Connected Conversations

Chat becomes your smart communication hub with Gemini. It summarizes discussions, tracks action items, and connects to your Drive files seamlessly. No more switching between apps to find that one piece of information – it’s all right there in your chat window.

• Context-Aware Replies: Respond to messages with Drive file references or summaries.
• Smart Suggestions: Get proactive suggestions to streamline collaboration.
• Action Items: Easily prioritize a list of action iteams.

Why This Matters for Solopreneurs

As a one-person show, your time is your most valuable asset. Gemini’s integration across Workspace isn’t just about individual features – it’s about creating a seamless work environment where your digital content works as hard as you do. No more context switching, no more lost time searching for files, and no more disconnected workflows.

The ability to reference your entire digital office while working in any Workspace app isn’t just convenient – it’s transformative. It’s like having your entire office organized and accessible through a single window, with an AI assistant who knows exactly where everything is and how it all connects.

Remember, Gemini isn’t here to replace your expertise – it’s here to amplify it. It handles the digital heavy lifting so you can focus on what really matters: growing your business and serving your clients.

Before diving in, make sure your Workspace is optimized to make the most of Gemini’s capabilities with my “How to Prepare Your Google Workspace for Gemini: A Clean-Up Guide“.

Getting Started

The best way to experience Gemini’s power is to start using it in your daily workflow. Begin with simple tasks like email drafting or document summarization, and gradually explore its more advanced features. Pay special attention to the side panel integration – it’s your gateway to a more connected and efficient digital workspace.

Your digital office just got a whole lot smarter! Welcome to the future of solo entrepreneurship, where AI doesn’t just assist – it transforms how we work. Are you ready to turn your digital workspace into your productivity powerhouse? Gemini is the partner you’ve been waiting for.

Wondering How Gemini Could Transform Your Specific Workflow?

Book a free Discovery Call, and let’s map out your personalized AI-powered workspace strategy. Together, we’ll identify where Gemini can make the biggest impact in your daily operations, saving you countless hours of digital busywork.

[Book Your Free Workspace Strategy Session] →

No generic solutions – just practical strategies tailored to your business needs.

The post Gemini in Google Workspace: Your AI-Powered Digital Office Assistant appeared first on Supernova Media.

Does it feel like you’re managing a never-ending avalanche of emails? I get it. The average professional will receive 121 emails per day. It can feel like trying to drink from a firehose. A survey revealed that 39% of workers check their email 3-5 times daily, while 27% check it 10-20 times a day. This accounts for about 28% of the workweek! Further research indicates that it takes, on average, about 23 minutes for professionals to regain focus after checking an email or experiencing any form of distraction.

These staggering numbers paint a clear picture: email management isn’t just a minor inconvenience—it’s a significant productivity drain. When nearly a third of our workweek is spent in our inbox – and each “quick” email check costs us valuable focus time – we need to rethink our relationship with email.

The good news? Gmail has built-in superpowers that can transform your chaotic inbox – no Gemini required. Let me introduce you to Gmail Filters and Labels – your new best friends in the battle against email overwhelm.

Understanding Gmail Filters: Your Personal Email Butler

Think of Gmail filters like your very own email butler. Just like you might tell a butler, “When my mother-in-law calls, tell her I’m in an important meeting,” you can instruct your Gmail butler to handle incoming emails according to specific rules. These filters work seamlessly behind the scenes, organizing your emails – exactly the way you want them.

Creating a filter is super easy. Let’s say you want to manage all those Amazon order confirmations automatically. The icon to the right of the Gmail search bar, shaped like a stack of horizontal sliders, opens up a world of filtering possibilities. (It replaced the older down-arrow design.)

It’s like writing a recipe for how you want your emails handled – you can set rules based on who sent the email, specific words in the subject line, or even attachments.

But the real magic happens when you decide what your filter should do. Want to automatically archive newsletters? Done. Need important client emails to be starred and marked as important? Easy peasy. You can even have certain emails skip your inbox entirely and go straight to where they belong. It’s like having a tiny automated assistant working 24/7 to keep your inbox clean.

Gmail Labels: Folders on Steroids

Let’s talk about labels – Gmail’s secret weapon for organization. If regular email folders are like basic filing cabinets, think of Gmail labels as a magical filing system where one email can exist in multiple places at once. Cool, right?

Creating labels is as simple as creating a new folder on your computer! Just like in Google Drive, you can color-code your labels (making your inbox look like a well-organized rainbow), and even create nested labels – think Russian nesting dolls, but for email organization. For instance, you might have a main label called “Projects” with sub-labels for each specific project, making it a breeze to find exactly what you need.

The Dynamic Duo: When Filters Meet Labels

Here’s the best part. When you combine filters and labels, you’re essentially creating an automated email sorting system. Imagine you’re working on multiple projects. You can set up filters to automatically label incoming emails based on project names, client emails, or specific keywords!

Picture this: Every morning, instead of facing an intimidating wall of unread emails, you’ll find everything pre-sorted. Client emails are properly labeled and prioritized, newsletters are neatly tucked away in their designated spots, and urgent messages are right where you need them. It’s like having your very own email concierge service!

Taking It to the Next Level: Advanced Techniques

For those who want to go even deeper, Gmail offers some seriously powerful advanced filtering options. Using search operators (think of them as secret codes), you can create incredibly precise filters. For example, you can filter emails that are older than a certain date, contain specific attachments, or even use regular expressions for pattern matching.

Here’s a pro tip: you can combine multiple criteria to create super-specific filters. Maybe you want to catch all emails from your team that contain the word “urgent” but only if they’re sent during business hours. Yes, that’s totally possible!

Want a Google search operator cheat sheet that’ll make you the search wizard? I’ve got you covered!

Beyond Basic Automation

But wait, there’s (even) more! Gmail’s automation capabilities extend far beyond just filters and labels. Have you heard about “Canned Responses” or Email templates? They’re like text message shortcuts, but for entire emails. Here’s a quick guide on How to Setup Email Templates. And if you’re feeling extra adventurous, I love IFTTT and Zapier for connecting Gmail to my other apps, creating powerful automation workflows.

Real-World Magic in Action

Let’s look at some practical examples. Say you’re drowning in newsletters. Set up a filter to automatically label them as “Newsletters” and skip the inbox – boom, instant organization. Or maybe you’re tracking expenses: create a filter that catches all receipts and forwards them to your expense-tracking software. The possibilities are endless!

Your Turn to Shine

Remember, the beauty of Gmail filters and labels is their flexibility. What works for one person might not work for another, and that’s perfectly fine. Start small, experiment with different combinations, and gradually build a system that feels natural to you.

Remember: Rome wasn’t built in a day, and neither is the perfect email organization system. Start with one or two filters, add a few labels, and trust me, your future self will thank you!

Drowning in Emails? Let’s Build Your Custom Email Command Center

You’ve got the basics of Gmail Filters and Labels – that’s step one! But if you’re ready to transform your inbox from “mostly organized” to “fully automated productivity machine,” let’s talk. During our free 30-minute Discovery Call, we’ll:

• Analyze your current email patterns and pain points
• Design a custom Gmail automation strategy for your specific workflow
• Explore advanced automation possibilities beyond basic filters
• Create a roadmap for implementing your personalized email system

Think of it as consulting with a digital architect who’ll help design your dream email workspace – one where emails automatically flow to exactly where they need to be, and you can focus on what truly matters in your business.

[Book Your Free Email Automation Strategy Session] →

The post Taming Your Inbox: A Friendly Guide to Gmail Filters and Labels appeared first on Supernova Media.

You know exactly what you want to say to your clients. Getting it on paper? That’s where time disappears.

Now imagine having a brilliant assistant who could draft that perfect response in seconds. That’s the power of Gemini in your Google Workspace – IF you know how to ask.

New for Q4 2024: Gemini will be available at no additional cost for Google Workspace users! Not sure if Google Workspace is right for your business? Check out my guide: [Is Google Workspace Right for Your Solo Business? A Solopreneur’s Guide]

What Makes Gemini Your Perfect Business Partner?

Think of Gemini as your AI-powered executive assistant who can:

• Read and understand documents, images, and spreadsheets
• Write everything from quick emails to detailed reports
• Help during video calls and presentations
• Analyze your business data and suggest improvements

The secret to making this partnership work? Learning to communicate effectively with Gemini.

How Gemini “Thinks”

Imagine explaining a task to a new assistant. They’re brilliant but literal – they need clear context and specific instructions. Gemini works the same way:

• It analyzes your entire prompt for context clues
• It looks for specific instructions and parameters
• It considers any examples you provide
• It learns from your feedback and iterations

Speaking Gemini’s Language: A Simple Framework

Before we dive in, let’s take a look at 5 Tips to write better prompts for Gemini:

Start with Your Goal in Mind

Before typing anything, think about what you want from Gemini. Are you writing an email, summarizing a document, or generating an idea? Being specific helps Gemini zero in on what you need.

• Vague Prompt: “Help me with marketing.”
• Clear Prompt: “Create a 3-sentence summary of this marketing strategy document aimed at Instagram influencers.”

Use Multimodal Inputs

One of Gemini’s superpowers is its ability to handle multiple input types. If your request involves both text and visuals, let Gemini know.

For example:

• Upload a product image and ask, “Write a description for this product emphasizing its eco-friendly features.”
• Insert a spreadsheet and prompt: “Create a summary of these sales figures in bullet points for my team meeting.”

This multimodal capability means Gemini can help you visualize your ideas or analyze your data alongside text-based tasks.

Experiment with Tone and Style

Here’s some good news: Gemini can adapt its tone to match your brand voice! If you want a formal, professional response or a lighthearted, conversational one, specify it in your prompt.

• Tone Prompt Example: “Write this email in a friendly tone but keep it professional. It’s for a client who’s considering my services.”

Just like choosing the right tone in person, picking the right “voice” for your AI output can make or break your communication. Let’s take a look at how you can control Gemini’s tone…

Iterate and Refine

Not happy with Gemini’s first response? No problem. You can always tweak your prompt and ask for adjustments.

• Example: “Make this email shorter and more persuasive.”
• Example: “Rewrite this blog introduction to sound more relatable to busy solopreneurs.”

Common Prompting Scenarios for Solopreneurs

Here are some practical ways you can use Gemini in your business:

1. Content Creation
   • “Draft a LinkedIn post for solopreneurs about saving time with Gemini.”
   • “Create 3 blog title ideas about AI automation for small businesses.”
2. Email Management
   • “Write a follow-up email to a client I pitched during our discovery call. Keep it polite and ask for feedback.”
3. Data Insights
   • “Analyze this spreadsheet of expenses and highlight the top three areas I can cut costs.”
4. Visuals and Presentations
   • “Turn these bullet points into a visually engaging slide for my webinar on time management.”

Gemini’s Special Powers (And How to Use Them)

Working with Images

• “Analyze this screenshot and explain the main trends in the data”
• “Look at this logo design and suggest three improvements”
• “Review this presentation slide and make it more engaging”

During Video Calls

• “Take notes during this client meeting”
• “Summarize the key action items from this discussion”
• “Draft follow-up emails based on this conversation”

Document Analysis

• “Summarize this 20-page report into 3 key points”
• “Extract the most important metrics from this PDF”
• “Compare these two proposals and highlight the main differences”

Pro Tips for Getting Better Results

Before you start crafting prompts, make sure your Google Workspace is optimized for Gemini integration. Need help getting organized? Read [How to Prepare Your Google Workspace for Gemini: A Clean-Up Guide] first.

1. Be Specific: The more precise you are, the more accurate Gemini’s response. Avoid vague phrases like “help me” or “do this.”
2. Provide Examples: If you have a specific format in mind, share it. For example, “Write this email like the example below.”
3. Test Multimodal Features: Upload files, images, or charts to see how Gemini can integrate them into its response.
4. Keep Learning: Experiment with prompts regularly to discover what works best for you. The more you practice, the better you’ll become at communicating with Gemini.

When the Output Isn’t Quite Right: Your Refinement Guide

1. Adjusting Quality

“Make this more…”

• Persuasive by adding data points
• Concise by cutting it to 3 paragraphs
• Action-oriented with clear next steps
• Professional by removing casual language
• Engaging by including relevant examples
• Descriptive with sensory details

2. Fine-Tuning Tone

“Adjust the tone to be more…”

• Empathetic toward client challenges
• Authoritative with industry insights
• Friendly while maintaining professionalism
• Direct with clear recommendations
• Encouraging for coaching clients
• Casual for social media posts

3. Audience Adaptation

“Rewrite this for…”

• Non-technical business owners
• Clients considering our services
• Existing customers needing support
• Senior professionals (50+)
• Industry newcomers
• Decision-makers in larger companies

4. Adding Detail

“Add more details about…”

• Implementation steps
• Cost-saving benefits
• Time requirements
• Success examples
• Technical specifications
• Available options

5. Format Refinements

“Restructure this to…”

• Break into shorter paragraphs
• Include bullet points for key ideas
• Add subheadings for better scanning
• Start with the main benefit
• End with a stronger call-to-action
• Include transition sentences

Pro Tip: Combining Refinements

You can stack these requests: “Please make this more concise and professional, then add specific examples for senior business owners.”

Remember: Gemini learns from your refinements. Each iteration helps it better understand your preferences and style.

From Writing Prompts to Writing Time Off!

Think of mastering Gemini prompts as your first step toward true business automation. Now that you understand how to communicate effectively with your AI assistant, why stop at just drafting content? It’s like upgrading from a basic assistant to an executive partner who anticipates your needs and delivers exactly what you want!

Ready to Transform Your Business from Manual to Magical?

Book a free Discovery Call with me! Think of it as consulting with your personal AI translator who’ll help you get the most out of Gemini in your Google Workspace. We’ll explore how to turn your newfound prompting skills into a complete business automation system that gives you back hours in your day.

[Book Your Free Gemini Automation Strategy Session]

P.S. Come to the call with your most time-consuming writing and admin tasks – still spending hours drafting emails and creating content? Let’s teach Gemini to handle that!

Listen to This Article 🎧

Want to experience the future of AI in Google Workspace? This audio version was created using NotebookLM’s which will soon be able available directly in Google Workspace with Gemini.

The post The Complete Solopreneur’s Guide to Mastering Gemini Prompts appeared first on Supernova Media.

As a solopreneur, you’re wearing multiple hats – from CEO to administrative assistant. Having the right digital tools isn’t just convenient; it’s essential for running your business efficiently. Google Workspace (formerly G Suite) has become increasingly popular, but is it worth the investment for your solo venture?

What’s in it for Solopreneurs?

Let’s focus on the features that matter most when you’re running a business single-handedly:

Essential Tools for Daily Operations

Is your Google Drive already feeling overwhelming? Read Is Your Google Drive a Digital Junk Drawer? Here’s How to Fix That! for a step-by-step cleanup strategy.

• Professional Email (@yourbusiness.com): Build credibility with clients using a custom email domain instead of @gmail.com
• Calendar: Manage client appointments, deadlines, and personal tasks in one place – crucial for solo time management
• Drive: Store and organize all your business files securely with 30GB to 5TB storage, depending on your plan
• Docs, Sheets & Slides: Create proposals, track expenses, and build client presentations professionally

Client-Facing Features

• Meet: Host professional video calls with clients (up to 250 participants)
• Forms: Create client questionnaires, feedback surveys, and intake forms
• Sites: Build a simple business website or client portal without coding skills

Why It Makes Sense for Solo Businesses

Coming Soon: AI-Powered Workspace with Gemini

Want to get your Workspace ready for Gemini? Check out our detailed guide: How to Prepare Your Google Workspace for Gemini: A Clean-Up Guide

For solopreneurs who need to maximize their productivity, the upcoming integration of Gemini into Google Workspace is a game-changer. This AI assistant is expected to help solo business owners:

• Draft and edit business communications faster
• Generate creative content and ideas
• Analyze data and create insights
• Automate repetitive tasks

This addition makes Google Workspace an even more compelling choice for solopreneurs who want to leverage AI to compete with larger businesses.

Time-Saving Benefits

• Everything Connected: Your email, calendar, and documents work together seamlessly
• Smart Features: Gmail’s AI-powered writing suggestions and calendar scheduling save precious minutes
• Mobile-First: Manage your business from your phone when you’re on the go

Professional Image

• Custom Email Domain: Look professional with @yourbusiness.com
• Branded Video Calls: Present a polished image in client meetings
• Collaborative Features: Work smoothly with clients and contractors when needed

Cost Considerations

• Business Starter: $6/month – Perfect for most solopreneurs
• Business Standard: $12/month – Worth it if you need more storage and longer video calls
• Business Plus: $18/month – Consider if you need advanced security features

How It Compares to Alternatives

Comparison with Microsoft 365:

• Pros for Solopreneurs:
  • Simpler Interface: Google Workspace offers a user-friendly, intuitive interface, which can be advantageous for users seeking straightforward navigation.
  • Real-Time Collaboration: Google Workspace excels in real-time collaboration, allowing multiple users to edit documents simultaneously with ease.
• Cons:
  • Less Robust Desktop Apps: Google Workspace primarily operates in the cloud, and its offline capabilities are less comprehensive compared to Microsoft 365’s robust desktop applications. This can be a limitation for users who frequently work offline.

Comparison with Zoho Workplace:

• Pros for Solopreneurs:
  • Integration with Google Services: Google Workspace integrates seamlessly with other Google services, such as Google Drive, Calendar, and Meet, which are widely used and can enhance productivity.
• Cons:
  • Higher Cost: Google Workspace’s pricing is generally higher than Zoho Workplace’s basic plans, which may be a consideration for budget-conscious solopreneurs.

Additional Considerations:

• Security and Support: Google Workspace offers robust security features and 24/7 support, which can be crucial for solopreneurs managing sensitive information.
• Scalability: Google Workspace is designed to scale with your business, offering various plans and features that can grow with your needs.

Making the Decision

As a solopreneur, Google Workspace makes the most sense if you:

• Need to present a professional image to clients
• Work primarily online and collaborate with clients digitally
• Want an all-in-one solution rather than piecing together different tools
• Value simplicity and don’t want to deal with complex software

It might not be worth it if you:

• Already have a professional email solution
• Mainly work offline
• Need advanced features in specific areas (like complex spreadsheets)

Try Before You Commit

Google offers a 14-day free trial, perfect for testing how it fits into your daily workflow. Start with the Business Starter plan – you can always upgrade as your business grows.

Quick Setup Tips for Solopreneurs

1. Set up your professional email first
2. Import your existing calendar and contacts
3. Create folder structures in Drive for different clients/projects
4. Set up email templates for common client communications
5. Configure your Meet settings for professional video calls

The Bottom Line

For most solopreneurs, Google Workspace offers an excellent balance of professional features, ease of use, and value for money. The professional email address alone often justifies the starter plan’s cost, with all other features being valuable additions to your business toolkit.

Remember: Your time is your most valuable asset as a solopreneur. If Google Workspace can save you even an hour a month through better organization and automation, it’s likely worth the investment.

Ready to Transform Your Solo Business with Google Workspace?

Think of Google Workspace as your virtual executive assistant – one that works 24/7 to keep your business running smoothly. The professional tools and AI-powered features we’ve explored are just the beginning of what’s possible when you optimize your digital workspace!

Ready to Make Google Workspace Work Harder for Your Business?

Book a free Discovery Call with me! Think of it as your personal consultation with a Google Workspace architect who understands the unique challenges of running a solo business. Together, we’ll design a custom workspace setup that makes you look and operate like a much larger company. Book Your Free Google Workspace Strategy Session

P.S. Bring your biggest time-wasters to our call – still juggling multiple tools or spending hours on repetitive tasks? Let’s explore how Google Workspace’s automation features can give you those hours back! 😊

The post Is Google Workspace Right for Your Solo Business? A Solopreneur’s Guide appeared first on Supernova Media.

Ever opened your Google Drive and felt like you just walked into a teenager’s bedroom? Documents scattered everywhere, mysterious folders from 2019, and that presentation you swear was titled “Final_FINAL_v2_actually_final.pptx”? Don’t worry – you’re not alone, and I’m here to help you transform your digital disaster into a zen paradise!

Step 1: The Great Purge

First things first – let’s channel our inner Marie Kondo. Open your Drive and take a deep breath. Now, let’s be honest: do you really need that meme collection from 2018? Or that recipe for avocado toast you’ve never made? Start moving files you haven’t touched in ages into a folder called “Archive” (because “Digital Guilt Trip” wouldn’t be professional).

Pro tip: Sort your files by “Last modified” and prepare to be shocked at how many files you forgot existed!

Step 2: Folder Framework

Time to create a folder structure that makes sense! Think of your Drive like a well-organized house:

• 📁 Work (Your office)
  • 📁 Projects
  • 📁 Templates
  • 📁 Reports
• 📁 Personal (Your living room)
  • 📁 Finance
  • 📁 Travel
  • 📁 Photos
• 📁 Archive (Your basement)

No more dropping files on your Drive’s “front lawn” like a digital litterbug!

Step 3: The Naming Game

Let’s talk about file names. “Screenshot 2024-01-15 at 15.43.22.png” is not helping anyone. Instead, try:

• Use dates in YYYY-MM-DD format (2024-01-15_Monthly_Report)
• Add project names or categories (Marketing_Logo_Draft_v1)
• Keep it simple but descriptive (2024_Tax_Documents)
• Rightclick on a folder or file to Rename it.

Renaming files and folders:

1. Find it: Go to your Google Drive and find the file or folder you want to rename.
2. Right-click: Right-click on the file or folder. This will open a menu.
3. Choose “Rename”: Select “Rename” from the menu.
4. Type the new name: A box will appear where you can type the new name.
5. Press “Enter”: Once you’ve typed the new name, just press the “Enter” key on your keyboard.

Remember: Future You will thank Present You for being so thoughtful!

Step 4: Share with Care

Sharing settings in Google Drive are like party invitations – you need to be strategic about who gets in. Create these sharing groups:

• VIP Access (Edit rights for your close collaborators)
• View Only (For those who can look but not touch)
• No Access (For that one colleague who “accidentally” deletes things)

To share and set permissions for a file or folder:

1. Select the folder you want to share.
2. Right Click and Click Share.
3. Type in their email. In the box that pops up, type the email address of the person you want to share with.
4. Choose what they can do.
   • Can view: They can only look at the file.
   • Can comment: They can look at the file and leave comments.
   • Can edit: They can look at, comment, and make changes to the file.
5. Click “Send” (or “Share”). That’s it! You’ve shared your file.

Step 5: Color Code Like a Boss

Did you know you can color-code folders in Google Drive? It’s like giving your digital filing cabinet a makeover:

• Red for urgent projects
• Blue for completed work
• Green for active projects
• Yellow for personal stuff

Now your Drive looks like a beautiful rainbow of organization!

Step 6: The Maintenance Dance

Like any good habit (or unlike the treadmill you don’t use) maintaining your Drive needs regular attention:

• Schedule monthly clean-up sessions
• Move completed projects to appropriate archives
• Update sharing permissions when team members change
• Delete or archive unnecessary files

The Final Touch

Remember, organizing your Google Drive isn’t just about having a clean space to welcome Gemini – it’s about making your digital life easier. Think of it as creating a cozy digital home where everything is in its place, and you’re not constantly yelling “Where did I put that file?!” at your screen.

And if all else fails, there’s always the search bar – Google Drive’s equivalent of asking your mom where she put your stuff!

Now go forth and organize! Your future self will thank you when they can find that important document in 2.5 seconds flat instead of diving into the depths of “Untitled folder (12).”

Happy organizing! ✨

From Organized Drive to Automated Workflow!

Think of this Google Drive cleanup as just the first step in your digital transformation journey. Now that you’ve transformed your Drive from a digital junk drawer into an organized space, why stop there? It’s like upgrading from a basic filing cabinet to a smart storage system that knows exactly where everything should go!

Ready to Level Up from Organized to Automated?

Book a free Discovery Call with me! Think of it as consulting with a digital architect who’ll help design your dream Google Workspace. We’ll explore how to transform your newly tidied Drive into a self-maintaining system that keeps your digital life running smoothly.

[Book Your Free Google Workspace Automation Consultation]

P.S. Come to the call with your most time-consuming Drive tasks – still spending hours organizing files and folders? We’ll find a way to automate that! 😉

The post Is Your Google Drive a Digital Junk Drawer? Here’s How to Fix That! appeared first on Supernova Media.

We’ve all been there – the doorbell’s about to ring, and you’re still frantically shoving clutter into closets and wiping down the counters. And just like you wouldn’t invite guests into your messy home – you shouldn’t welcome Gemini into a cluttered Google Workspace. I’m not talking about a 10-second today here… this is the digital equivalent of hiding those embarrassing family photos and vacuuming under the couch cushions.

1. The Great Google Drive Decluttering

Remember that “misc” folder from 2019? Yeah, it’s time to deal with that. Before Gemini moves in:

• Create a logical folder hierarchy (Projects > Year > Quarter)
• Implement consistent naming conventions (YYYY-MM-DD_ProjectName_DocumentType)
• Delete or archive duplicate files
• Move old projects to an “Archive” folder

Pro tip: Think of folders like rooms in your house. You wouldn’t keep your cooking supplies in the bathroom, so why is that marketing presentation in your development documentation?

2. Become a Search Ninja

Google’s search operators are like cheat codes for finding exactly what you need, faster than you can say “Where’s that file?!”

• Master Google’s search operators like type:, owner:, before:, after:
• It’s like having a secret map to find exactly what you need, when you need it.

Want a Google search operator cheat sheet that’ll make you the search wizard of your workplace? I’ve got you covered:

Or try this prompt in Sheets with Gemini to create your own:

Create a spreadsheet listing Google search operators with the following columns: “Operator”, “Function”, “Example”, and “Category”. Break the data into three categories: “General Operators”, “Drive Operators”, and “Gmail Operators”. For each operator, include several relevant example that shows its usage. Format the spreadsheet to include headers and align the data neatly.

Categories:

1. General Operators:
   • Search operators applicable universally on Google (e.g., site:, intitle:, etc.).
2. Drive Operators:
   • Operators specific to Google Drive searches (e.g., type:, owner:, etc.).
3. Gmail Operators:
   • Operators specific to Gmail searches (e.g., label:, is:, etc.).

3. Inbox Zero(ish)

Your email inbox is like your kitchen counter – it shouldn’t be used for storing items from last year. Take these steps:

• Archive emails older than 12 months
• Create labels for ongoing projects
• Set up filters for automated sorting
• Clear out your spam folder

Think of it this way: If your physical mailbox was stuffed with year-old magazines, you’d have trouble finding today’s important letters.

4. Clean Up Your Calendar

Just like you’d clear space in your closet for a guest’s coat, make room in your calendar:

• Delete or archive old recurring meetings
• Clean up declined invitations
• Update timezone settings
• Remove access for departed team members

5. Review Access and Permissions

The digital equivalent of deciding who gets a spare key to your house:

• Audit shared drive permissions
• Update group memberships
• Review third-party app access
• Check external sharing settings

6. The Final Touches

Like fluffing the pillows and lighting a scented candle:

• Update your Workspace settings
• Check storage capacity
• Test integrations
• Document your new organization system

Remember: A tidy digital space isn’t just about impressing your new AI assistant – it’s about creating an environment where both you and Gemini can work efficiently together.

The Payoff

Just like a clean home makes life – just better, an organized Google Workspace will help you:

• Find files faster
• Collaborate more effectively
• Reduce digital clutter anxiety
• Make the most of Gemini’s capabilities

Now you’re ready to welcome your new digital assistant into a workspace that Marie Kondo would approve of. And unlike human guests, Gemini won’t judge you for those questionably named files from 2018 – but let’s clean those up anyway.

From Spring Cleaning to Smart Home Automation!

Think of this as just the first episode of your digital decluttering journey. Now that you’ve decluttered your digital space for Gemini, why stop there? Think of this as upgrading from basic tidying to installing a full smart home system! Read “Streamlining Your Business with Google Workspace Automation,” to see how I help fellow solopreneurs turn their digital space from a cluttered cottage into a smart home that practically runs itself!

Ready to Level Up from Clean to Automated?

Book a free Discovery Call with me! Think of it as consulting with a digital architect who’ll help design your dream workspace. We’ll explore how to transform your newly organized digital space into a fully automated command center for your business.

[Book Your Free Automation Consultation] →

P.S. Bring your biggest time-wasting tasks to the call – if you’re spending hours on repetitive work, we’ll find a way to automate it! 😉

The post How to Prepare Your Google Workspace for Gemini: A Clean-Up Guide appeared first on Supernova Media.

Creating high-quality, consistent content across platforms is a demanding task – especially for solopreneurs. Managing multiple formats, tools, and audiences can quickly become overwhelming.

I’ve found a better way with automation. It helps me streamline the content creation process – saving me time on repetitive tasks – and ensuring relevant, accurate analysis.

Let me walk you through my automated content workflow. It’s perfect whether you’re flying solo, running a small business, or even part of a marketing team. Psst – there’s a TL;DR at the bottom.

Why Automate Your Content Creation Workflow?

Let’s face it – content creation is more than just writing. It’s research, organization, formatting, and strategy. Here’s what automation did for me:

• Saved me hours each week (hello, more time in my zone of genius)
• Kept my messaging consistent everywhere
• Gave me space to actually be creative

My workflow is broken down into five key stages, each powered by automation to keep everything organized and efficient.

1. Idea Generation – Never Run Out of Ideas Again

My secret weapon? A combination of smart tools:

Tools Used: Google Alerts, Google Analytics, Zapier, Perplexity Research, Siri

• Google Alerts keeps me in the loop with industry news
• Audience engagement data tells me what actually works by automatically feeding insights from Google Analytics into my Notion Content OS via Zapier.
• Perplexity Research digs deep and saves everything to Google Drive
• Siri captures my random bursts of inspiration and saves directly to my Notion Content OS.

2. My Content Command Centre

Everything lives in Notion (my Content OS) – my digital brain. Here’s why it’s SO special.

Tool Used: Notion, Custom GPT, Zapier

• Content OS: Think of Notion as my content command center. It’s where all my ideas, research notes, posts – and what my audience is saying – all under one roof.
• Automated Feedback Loop: With Zapier, engagement data is automatically gathered and fed into Notion. Everything’s connected, so I can easily spot patterns.
• Custom GPT: Trained on my ideal customer profile (ICP) and preferred formats. (see formats below). Psst – everything you need to know about Custom GPTs.

3. Templates & Content Development – Keeping it On-Brand

Visual consistency is key. Here’s how I nail it:

Tools Used: Canva (for template design), Custom GPT (for initial drafts)

• Templates for Specific Formats: I have pre-designed templates for each content type, such as tutorial carousels, ICP carousels, single posts, and videos. This keeps my content visually aligned across platforms.
• Custom GPT: My GPT is set up to adapt content to fit each template, which speeds up the process and ensures that each piece is ready for publishing without additional formatting.

4. Publishing & Scheduling – Post Like a Pro

Tool Used: Buffer

• Multi-Platform Scheduling: With Buffer I can set specific times and dates for each post, making adjustments per platform.
• Batch Scheduling: Think sweatpants, tea and lazy-boys. I set Friday afternoon aside for content creation and look forward to this time all week. I enjoy it so much it feels like I’m skipping off early! I’ve scheduled an entire month of fresh and stellar content while in my zone of genius.

5. Content Refresh & Repurpose – Make Your Best Content Work Harder

Process: I automatically tag posts with high engagement (page views, click-through rates, conversions) in my “Repurpose Queue” within Notion. Google Analytics provides real-time performance data, which Zapier pulls into my Content OS.

Why start from scratch when your existing content can do more? I:

• Tag high-performing posts for future updates
• Refresh old favorites with new insights
• Keep my best content working for me long-term

TL;DR

Here’s how everything flows in my content creation workflow:

1. Idea Generation feeds relevant topics into Content Management & Automation within Notion, where content is organized and prioritized.
2. Outside of Notion, Custom GPTs generate draft content and suggest ideas tailored to my ideal customer profile and format. These drafts are then refined and aligned with templates for consistent branding.
3. Once finalized, completed content moves to Publishing & Scheduling with Buffer, where it’s queued for posting.
4. Finally, high-performing posts are tagged within Notion for the Content Refresh & Repurpose stage, ensuring valuable content is easily accessible for future updates and repurposing.

It’s like having a content creation machine that just… works.

Want Content Creation to Feel Effortless? Let’s Make It Happen!

You know what’s better than having an amazing content system? Building one for others!

Here’s What Knocks My Socks Off

I love watching clients go from feeling overwhelmed to in the zone, managing their content like pros. No more laying in bed staring at the ceiling and stressing about what to post this week!

What Working Together Looks Like

When we team up, you get:

• Your very own Notion client portal (think of it as your content command center!)
• A custom Content OS built just for you and your unique needs
• A system that grows with your business (no outgrowing this bad boy!)

The Best Part?

We’ll look at the tools you already use and love, your unique ICP, and your goals to create something that feels as unique as you are. No one-size-fits-all box here!

This Isn’t Just Another Template

Think of it as your forever content home. Once we set it up together, it’s all yours! You’ll have a system that:

• Runs like clockwork (even when you’re on vacation)
• Makes content creation feel fun, not overwhelming
• Keeps working for you long after our collaboration ends

Ready to Make Content Creation Fun?

Let’s chat about turning your content creation process around. It might be the best investment you make this year!

The post How to Streamline Content Creation with Automation: My Complete Workflow appeared first on Supernova Media.

As a solopreneur for more than two decades, I’ve been using Google Workspace as a secure, flexible, efficient, and affordable solution for productivity tools. The last year and a half have been about exploring AI tools like ChatGPT that can enhance my productivity, streamline and optimize my operations, – so today I’m comparing Custom GPTs vs Gemini Gems. Let’s get to it:

OpenAI’s Custom GPTs and Google’s Gemini Gems are both examples of personalized AI assistants. They are tailored versions of their respective AI’s, and custom designed (by you) to specific use cases. For me – they take care of everything from 15-minute meal ideas to managing my online store and finding daily motivation.

Launched August 28th, Gems are available to premium users. We’ll learn more about them below. And here’s everything you need to know about Custom GPTs.

Side note: I recently polled my LinkedIn audience to see which productivity tool they were using. Looks like I’m in good company. 😉



Back to Custom GPTs vs Gemini Gems. I’ve been building Custom GPTs since their launch in November 2023 with 21 in my Arsenault. Sound cumbersome? It is… As a die-hard Google Workspace user, I have to say: I’m sold on Gems.

Here’s why:

1. User-Friendliness is King

One of the biggest reasons I’m sold on Gems is how easy they are to set up.

PyPilot was one of the first GPTs to hit the GPT Store – designed as an interactive course to teach Python to beginners. And within hours – there were six iterations available. 😡 But that’s another story. Don’t bother search for it – it’s unpublished – and I won’t be publishing anymore. Read the PyPilot case study here.



PyPilot’s use case was unique. I didn’t want the bot to “think” – the goal was that every user would have the (exact) same experience – which required a script. Achieving this was time-consuming with many iterations and fine-tuning and I learned to structure my files consistently using markdown. Learn how to structure your data for GPT’s.

Despite every best practice, the results remained inconsistent.

And I wasn’t the only one who felt that way:

.
So I tried harder….  And for each of my Custom GPT “major players,” I established a framework in Notion that looks like this:

Spoiler alert – the results are improved but definitely not perfect. 🤷🏻‍♀️

For beginners, I love that Gemini Gems come with pre-set templates. This makes it less scary for some and a great choice for newbies. You simply provide instructions (up to a massive 15,000 tokens), name your Gem, and you’re ready to roll!

2. No Need for Manual File Uploads

This is a game-changer. With Custom GPTs, if you want the AI to access specific documents or data, you have to upload those files or feed them manually. Gemini Gems completely eliminate that hassle by tapping directly into your Google Drive, Docs, and Gmail. They dynamically access files in real-time, which means that as you modify or update your files, your Gems get access to the most recent data—automatically! 

Imagine you’re working on a project where you update in Google Sheets. Your Gem will automatically incorporate those changes without needing you to re-upload the document. (happy dance)

I’ll still follow the framework established in Notion, but the database will go by the wayside in favor of hosting my files on Drive. This will make my workflow so much more efficient! 

3. Dynamic Updates with Real-Time Data

If you’re a Custom GPT builder, you know it’s an iterative process and real-time dynamic updates are where Gemini really shines. As I modify files in my Google Workspace apps, the Gem is aware of these updates in real-time. There’s no need for re-uploading files, meaning you always have the most current information for your tasks. This creates a smooth, dynamic workflow that improves over time.

For example, when managing a campaign across various documents, I can trust that the assistant will always pull the latest data, making task management seamless and error-free. I’m here for it! 👏🏻

4. Bigger Capacity: 15,000 Token Limit

Complex tasks require more processing power, and that’s where Gemini Gems hold a serious edge. With a 15,000-token limit, Gems can handle more intricate prompts and tasks compared to OpenAI’s Custom GPTs, which cap at 4,096 tokens. This is a major plus for handling complex workflows and larger datasets. Hint: this is one of the main reasons PyPilot was buggy – my knowledge base files are resource-intensive. 

5. Seamless Integration with Google Workspace

Finally, the seamless integration of Gemini Gems with Google Workspace is where the real magic happens. Everything I do—from document creation in Google Docs to email automation in Gmail—flows naturally into my Gem’s capabilities. This means I can leverage AI without switching platforms (it’s a one-tab wonder) making it an easy fit for solopreneurs already using the Google ecosystem.

Custom GPTs vs Gemini Gems: The Verdict

Both Custom GPTs and Gems offer exciting possibilities for personalized AI assistance. But for Google Workspace users, Gems’ user-friendliness, seamless integration, dynamic updates, and larger capacity make them the clear winner in my book.

If you’re a Google Workspace user, I highly recommend giving Gems a try. I think you’ll be just as impressed as I am. You’ll see firsthand how they can help reclaim time, streamline workflows, and boost productivity.

Meet NotebookLM

Looking for an easy way to turn your content into engaging audio? With just a few clicks, I used NotebookLM (powered by Gemini 1.5 Pro multimodal) to transform this blog post into a radio-quality audio summary! 🎙️

The result? A human-like 6:36-minute conversation deep diving into the insights – it’s next level! 

FYI: NotebookLM lets you upload up to 50 source files with a total of 500,000 words each – imagine the possibilities!

Want to hear how it sounds? Check out the audio clip below.

CustomGPTs vs Gems

Ready to make the switch? Let’s talk about how you can incorporate Gemini Gems into your workflow today!

BONUS: Streamline Your Workflow: Access 1300+ Custom GPTs with Notion Database Guide

The post Custom GPTs vs. Gems: And Why Gems Is My New BFF appeared first on Supernova Media.

Remember when we thought having multiple tabs open meant we were being productive? Those days are over.

Google’s Gemini, the whiz-kid AI assistant, just got a massive upgrade that’s about to change how you work – for the better. It’s like having a super-smart assistant who has memorized your entire digital office.

Effortless Information Retrieval

Picture this: You’re in Gemini, asking a question about last quarter’s report. Instead of opening another tab, digging through your Drive, or searching your email, Gemini does it all for you. It reads your documents, scans your emails, and gives you the answer – all without you lifting a finger. It’s like having a super-smart assistant who has memorized your entire digital office.

No More Copy-Paste Gymnastics. No More Tab-Hopping.

According to the International Data Corporation (IDC) and McKinsey Global Institute analysis:

• The average professional spends 28% of the workday reading and answering email.
• Nearly 20% is spent looking for internal information.

That’s almost half your day! But with Gemini Workspace Extensions, you’re about to get that time back.

What’s New?

Google Workspace extensions for Gmail, Google Drive, and Google Docs are now available in open beta for Gemini. This upgrade is available for Gemini Business, Enterprise, Education, and Education Premium add-ons. You can explore more at Gemini Google.

How To Turn On The Google Workspace Extension For Gemini

Before you set the extension, make sure you’re signed in to an administrator account, or ask your administrator for help. Here’s a quick guide to enable extensions:

Step 1:
In the Admin console, go to Menu > Generative AI > Gemini.

Step 2:
Scroll to “Extensions” and select “Allow users access to Workspace extensions in Gemini.”

Step 3:
Back in the Gemini app, you’ll need to turn on extensions here too. You can disable them at any time. Click Connect.

Start Your Chat

Type “@” in the text bar, and the drop-down will automatically appear for the user to select.

Important Note

To turn on Workspace extensions, Docs, Drive, and Gmail must all be turned on. Note that during the open beta period, the Context-Aware Access (CAA) feature will not be applicable. CAA is a security feature in Google Workspace that allows administrators to set rules about who can access certain apps and data based on specific conditions.

Extensions in Action

To use the extensions, tag your desired app with “@” in the text bar along with relevant keywords and action items for your request. For example:

• Example Prompt: “I need to prepare a client status report for my upcoming meeting with __. Please gather latest project documents from @Google Docs summarize the key points in recent emails in @Gmail and provide any insights on potential bottlenecks.”
• Response: Gemini references the necessary emails and docs without you needing to manually search.

Key Features

• Working Across Apps: Gemini pulls info from all your Workspace apps simultaneously, so you get the complete picture.
• Searching Your Drive: It easily finds files in your Drive and understands their content.
• Understanding Emails: It reads and comprehends all your emails, even the unread ones.
• Contextual Answers: It provides answers that are relevant to your specific situation.
• Simplifying Your Workspace: It brings everything you need into one smart interface.
• Staying Up-to-Date: It automatically syncs with your Workspace, so you always have the latest info.

Reclaim Your Time

Say goodbye to the 48% of your workday wasted on emails and searching, and hello to focused, efficient workdays.

Conclusion: One Tab, Endless Possibilities

Key Takeaways:

• Seamless integration across Workspace apps.
• Intelligent context from emails and documents.
• Drastically reduced tab-switching and searching.

Your next steps:

1. Activate Gemini Workspace Extensions today.
2. Explore its capabilities in your daily tasks.
3. Customize your workflow for maximum efficiency.

Want More? Subscribe to TechTactics

Every other Sunday, you’ll receive an email with:

1. One ChatGPT lesson.
2. Direct support via Slack.
3. Notion Workspace Hub.

We’re not just sending newsletters. We’re building a community and a toolkit that grows with you.

Subscribe to TechTactics

By leveraging the new Gemini Workspace Extensions, you can transform your productivity and streamline your workflow like never before. Explore the possibilities and let Supernova Media help you harness the power of custom AI solutions. Explore Our Services: Supernova Media Services

The post Reclaim Your Time with Gemini Workspace Extensions appeared first on Supernova Media.