Automated image optimizer: convert JPG/PNG to WebP with APYHub and Google Drive

This workflow automates the process of converting images from JPG/PNG format to WEBP using the APYHub API. It retrieves image URLs from a Google Sheet, converts the images, and uploads the converted files to Google Drive.

This workflow is a powerful tool for automating image conversion tasks, saving time and ensuring that images are efficiently converted and stored in the desired format.

Using WebP images on a website provides several SEO benefits:

1. Faster Loading Speed – WebP files are smaller than JPG and PNG, reducing page load times and improving user experience.
2. Better Core Web Vitals – Google prioritizes websites with good performance metrics like LCP (Largest Contentful Paint).
3. Improved Mobile Performance – Smaller images consume less bandwidth, enhancing mobile usability.
4. Higher Search Rankings – Faster sites tend to rank better on Google due to improved user experience.
5. Reduced Server Load – Lighter images lower hosting and CDN costs while improving site efficiency.

Below is a breakdown of the workflow:

1. How It Works

The workflow is designed to convert images from JPG/PNG to WEBP format and manage the converted files. Here's how it works:

1. Manual Trigger:

   • The workflow starts with a Manual Trigger node, which initiates the process when the user clicks "Test workflow."

2. Set API Key:

   • The Set API KEY node defines the API key required to access the APYHub API.

3. Get Images:

   • The Get Images node retrieves a list of image URLs from a Google Sheet. The sheet contains columns for the original image URL (FROM), the converted image URL (TO), and a status flag (DONE).

4. Get Extension:

   • The Get Extension node extracts the file extension (JPG, JPEG, or PNG) from the image URL and adds it to the JSON data.

5. Determine Image Type:

   • The JPG or PNG? node checks the file extension and routes the workflow to the appropriate conversion node:
     • JPG/JPEG: Routes to the From JPG to WEBP node.
     • PNG: Routes to the PNG to WEBP node.

6. Convert Image:

   • The From JPG to WEBP and PNG to WEBP nodes send POST requests to the APYHub API to convert the images to WEBP format.
   • The API returns the URL of the converted image.

7. Update Google Sheet:

   • The Update Sheet node updates the Google Sheet with the URL of the converted image and marks the row as done (DONE).

8. Get Converted Image:

   • The Get File Image node downloads the converted WEBP image from the URL provided by the APYHub API.

9. Upload to Google Drive:

   • The Upload Image node uploads the converted WEBP image to a specified folder in Google Drive.

2. Set Up Steps

To set up and use this workflow in n8n, follow these steps:

1. APYHub API Key:

   • Obtain an API Key from APYHub.
   • In the Set API KEY node, define the API key.

2. Google Sheets Integration:

   • Set up Google Sheets credentials in n8n for the Get Images and Update Sheet nodes.
   • Create a Google Sheet with columns for FROM (original image URL), TO (converted image URL), and DONE (status flag).
   • Provide the Document ID and Sheet Name in the Get Images node.

3. Google Drive Integration:

   • Set up Google Drive credentials in n8n for the Upload Image node.
   • Specify the folder ID in Google Drive where the converted images will be uploaded.

4. Test the Workflow:

   • Click the "Test workflow" button in n8n to trigger the workflow.
   • The workflow will:
     • Retrieve image URLs from the Google Sheet.
     • Convert the images to WEBP format using the APYHub API.
     • Update the Google Sheet with the converted image URLs.
     • Upload the converted images to Google Drive.

5. Optional Customization:

   • Modify the workflow to include additional features, such as:
     • Adding more image formats for conversion.
     • Sending notifications when the conversion is complete.
     • Integrating with other storage services (e.g., Dropbox, AWS S3).