Tech / Technology

Best SheetMagic deal: 83% off AI tool that combines ChatGPT with Google Sheets

Posted on:

A lifetime subscription to a SheetMagic Single User Plan is on sale for £40.54, saving you 83% on list price.
SheetMagic on laptop

TL;DR: A lifetime subscription to a SheetMagic Single User Plan is on sale for £40.54, saving you 83% on list price.

If you love both ChatGPT and Google Sheets, you’ll love how they work together in SheetMagic. It combines the AI power of ChatGPT with the organisation of Google Sheets to automate your workflow and streamline otherwise-repetitive tasks. Grab a lifetime subscription here for only £40.54.

SheetMagic allows you to generate AI content in bulk while organizing it into a Google Sheet. Instead of cramming everything into a regular ChatGPT prompt, you can sort data into columns and get better AI content.

Maybe you want to write captions for social media. Create a column to list products or ideas you want to share and use the “=AI(“Your Prompt Here”) function to generate content. Feel free to get as specific as you would with traditional ChatGPT, specifying a tone, targeted age range, and more.

Or, combine cells to streamline the process even more. Include SEO keywords, a product description, price, or anything else within your AI prompts to get detailed responses — just string them in like you would with any other function.

You can also sort AI-generated content into specific columns or tables. That means your AI content will be organised and readily available for use.

The versatility of SheetMagic doesn’t stop there. Take advantage of features like:

  • Insert URLs to get full page content right on Google Sheets. Then, use that content in your AI prompts to generate content.

  • Seamless use across languages. Just give your prompt in any language or use the tool for translation.

  • Get access to a prompt library that helps you discover the most effective way to structure your AI functions.

This lifetime subscription to SheetMagic supports unlimited usage. After you add your OpenAI API key, generate as much content as you need, for life.

Discover the wizardry of ChatGPT and Google Sheets with Sheet Magic, now only £40.54 for the lifetime single user plan.


SheetMagic logo

Credit: SheetMagic


SheetMagic Single User Plan (Lifetime Subscription)

£40.54 at the Mashable Shop

Tech / Technology

Google Chrome on iPhone now lets you move the address bar

Posted on:

Google Chrome users can now move the address bar to the bottom, but only iPhone users can take advantage of this new feature.
Google Chrome moves address bar

Google added a new feature to Chrome that is reminiscent of Safari’s current design. You can now move the address bar to the bottom of the screen.

This means you no longer have to stretch your thumbs to reach the top of your phone in a way that interrupts your typing flow. Sorry, Android users — this feature is only available to iPhone users at this time.

Google Chrome address bar move feature

You can move the Google Chrome address bar to the bottom or keep it at the top.
Credit: Google

Why move the address bar to the bottom?

Phones are gigantic these days. Hell, the Samsung Galaxy S23 Ultra and the iPhone 15 Pro Max have nearly seven-inch displays — they’re practically tablets.

Apple iPhone 15 Pro Max in white titanium

The iPhone 15 Pro Max in all of its giant glory.
Credit: Stan Schroeder / Mashable

As such, the top of the screen is becoming harder for our thumbs to reach. So Google is allowing users to move the address bar to a more convenient position.

“We know people prefer different address bar positions depending on the size of their hands and devices, and we took those preferences into account when building this highly requested feature,” said Nick Kim Sexton, Google product manager for Chrome.

If you prefer the address bar on top, don’t worry: You can simply leave it in its default position.

How to move the address bar to the bottom

To move the address bar to the bottom, you must press and hold it. Next, select the “Move address bar to bottom” option. That’s it!

You can also go to Settings, tap on “Address bar,” and choose your preferred position.


Google Pixel 8 Pro - Unlocked

Credit: Amazon


Google Pixel 8 Pro – Unlocked

$999

Tech / Technology

How to find your IP address

Posted on:

Here’s how to find your private and public IP address on whatever device you’re using.
Image of woman in a camper van using her laptop

An IP address is a unique number that identifies a device connected to the internet. IP which stands for “Internet Protocol,” is a set of rules that dictates how information is shared on the internet. An IP address is how and where that information should go. If the IP address is like a physical mailing address, IP is the part that tells you how to get there.

Every device actually has two IP addresses: the public/external address which is used to communicate with the wider internet and the private/internal address, which communicates with your local network aka your personal internet router.

Knowing your IP addresses is useful for a few different reasons, such as setting up a file server, adding a printer, or communicating with local devices on the same network. Because your IP address shares your location, it is also a way to understand how your personal information is shared. This is also why more and more people opt to use a VPN or “virtual private network” which obscures your actual location.

How to find your public/external IP address

Simply Google “what is my IP address” and the result will appear at the top of the page.

How to find your private/internal IP address

On a Mac

Total Time

  • 2 min
What You Need

  • Mac desktop or laptop

Step 1:

In “System Preferences” go to “Network.”

Step 2:

In this window, you’ll find your IP address right under the network status.

Screenshot of WiFi network settings on a Mac


Credit: Apple

On Windows

Total Time

  • 2 min
What You Need

  • Windows desktop or laptop

Step 1:

Open “Network & Internet,” then click “Properties” in WiFi or ethernet, depending on your connection.

Screenshot of Network and Internet settings on a PC


Credit: Windows

Step 2:

In “Properties,” scroll down to find IPv4 address. That is your local IP address.

Screenshot of Properties settings about internet connection


Credit: Windows

On an iPhone/iPad

Total Time

  • 2 min
What You Need

  • iPhone or iPad

Step 1:

Go to “Settings,” then “WiFi,” then select the network you’re connected to.

Step 2:

Your IP address is displayed in the section called IPv4 address.

Screenshot of WiFi network settings on an iPhone


Credit: Apple

On an Android/tablet

SEE ALSO:

The best antivirus software options for keeping PCs and Macs protected

Total Time

  • 2 min
What You Need

  • Android smartphone or tablet

Step 1:

Go to your WiiFi network settings, then select the network you’re connected to.

Step 2:

You’ll find your IP address along with the other network information.

Screenshot of WiFi network information on a Samsung Galaxy


Credit: Samsung

Tech / Technology

How to combine PDF files

Posted on:

This easy-to-follow walkthrough will show you exactly what you need to do to successfully combine two or more PDFs. Thanks, Adobe Acrobat.
An illustration of an open laptop and the PDF icon.

If you ever find yourself with the need to combine several PDFs into one single file, you may be immediately frustrated: It’s not immediately obvious how to achieve what you’re trying to do.

Luckily, Adobe, the creator of the PDF, offers a super-simple and free online tool that will help you combine your files in a matter of minutes. Read on for an easy-to-follow walkthrough that will show you exactly what you need to do to successfully combine two or more PDFs.

Using Adobe Acrobat’s online tool to combine PDFs

Adobe’s free online tool to combine PDFs offers a clean and simple interface that’s easy to understand.

The first time you use the tool, you don’t need to sign in, and you can just select to download your merged file when you’ve completed the process.

If you want to use the tool again, you will need to sign in with your Google, Facebook, or Apple account, or by creating an account with your email address and a password.

When you do sign in, you get the additional option to share your file by either generating a link or emailing it to others.

Combining PDFs files online

Total Time

  • 2 min
What You Need

  • Desktop or laptop
  • Adobe Acrobat

Step 1:

Get your PDF files into the main “Combine Files/Merge PDFs” box you will see at the top of the page. You can do this by dragging and dropping your PDF files into the box, or you can click the “Select Files” button..

"Combine Files" in Adobe Acrobat.


Credit: Screengrab: adobe

Step 2:

Once you’ve uploaded your PDF files, it’s just a matter of clicking the “Merge/Combine” option toward the top right of your screen. If you’re signed in, you’ll need to give the new file a name before the “Combine” button is clickable.

The "Combine Files" page in Adobe Acrobat with the "Enter new file name" field and the "Combine" button highlighted.


Credit: Screengrab: adobe. Kitten pics used with thanks to Unsplash / Kote Puerto / Andriyko Podilnyk / Bofu Shaw

What you can do with your combined PDF file

The completed "Combine Files" page with the "Share" and "Download" buttons highlighted.


Credit: screengrab: adobe. Kitten pics used with thanks to Unsplash / Kote Puerto / Andriyko Podilnyk / Bofu Shaw

After you’ve completed the combine process, you can download or share your new file.

From the completed merge screen, you’ll also see a menu on the right-hand side of the page.

The options menu from the completed "Combine Files" page.


Credit: screenshot: Adobe

This menu gives you further options to edit your file, including the ability to reorganize the pages, split the PDF, edit it, convert it into an alternative file format such as a JPEG or Word file, and to add a comment. Simply click on each option to make it happen.

Tech / Technology

Google Pixel tablet deal: Get $100 off a Google Pixel tablet at Amazon

Posted on:

As of Nov. 1, you can score a Google Pixel Tablet with a charging speaker dock for just $399 at Amazon. That’s $100 off the listing price and its lowest price ever.
person watching a TV show on a google pixel tablet

SAVE $100: As of Nov. 1, you can score a Google Pixel tablet with a charging speaker dock for just $399 at Amazon. That’s a 20% discount and $100 off the listing price — and its lowest price ever.


Google Pixel Tablet

Credit: Google


Google Pixel tablet with charging speaker dock

$399 at Amazon (save $100)



You don’t have to wait until Black Friday to save on electronics. Amazon is already offering some pretty sweet deals on laptops, tablets, and more, including a generous discount on Google’s latest Pixel tablet.

As of Nov. 1, you can snag a Google Pixel tablet at Amazon for just $399. That’s $100 off the original listing price or a 20% discount. It’s also the lowest price ever for this particular tablet model (yes, it’s lower now than it was on Prime Day 2). Best Buy and Target are also offering the same $100 discount on the Google Pixel tablet, so you have multiple options to grab this great deal.

SEE ALSO:

Google Pixel Tablet is finally here. See the specs, price, and more.

Whether you’re a student, a professional, or you need a new tablet for scrolling and streaming, the Google Pixel tablet is definitely worth considering. It has a high-resolution, 11-inch screen with vibrant colors and sharp details and an extra-long battery life that can last up to 11 hours. Plus, the (included) speaker dock that doubles as a speaker and a charging station is a great bonus.

“I hardly ever ripped the tablet off the dock,” writes Mashable tech and games reporter Alex Perry, who gave this tablet a 4/5 rating. “The speaker part of the speaker dock delivers big enough audio with adequate bass and whatnot that I wound up using the device to listen to music and podcasts as much as I used it to watch YouTube videos and Mets games on YouTube TV.”

Grab this tablet at a great discount while it lasts.