Convert image from jpg/png to webp

For Google Sheets, automate the conversion of JPG/PNG images to WEBP format, saving time and ensuring efficient storage. This workflow retrieves image URLs from a Google Sheet, processes the conversions using the APYHub API, and uploads the results to Google Drive, streamlining your image management tasks.

7/8/2025
12 nodes
Complex
manualcomplexgooglesheetsgoogle drivesticky noteadvancedlogicroutingapiintegration
Categories:
Complex WorkflowManual TriggeredData Processing & Analysis
Integrations:
GoogleSheetsGoogle DriveSticky Note

Target Audience

This workflow is ideal for:
- Photographers looking to optimize their images for web usage by converting JPG/PNG formats to WEBP, which significantly reduces file sizes without compromising quality.
- Web Developers who need to automate image processing tasks, allowing for faster website loading times and improved user experience.
- Content Creators who frequently upload images to their platforms and want to streamline the conversion process to save time and resources.
- Marketing Teams needing to ensure that their visual content is web-optimized for better engagement and performance.

Problem Solved

This workflow addresses the challenges of manually converting image formats by automating the process:
- Time Efficiency: It eliminates the need for manual conversions, allowing users to focus on more important tasks.
- Consistency: Ensures uniformity in image formats across projects, which is crucial for branding and presentation.
- Accessibility: By converting images to WEBP, users can significantly reduce loading times for their websites, enhancing user experience and SEO performance.

Workflow Steps

  • Manual Trigger: The workflow starts when the user clicks ‘Test workflow’.
    2. Set API Key: The user sets their API key for the APYHub service, which is essential for making conversion requests.
    3. Get Images: The workflow retrieves image URLs from a specified Google Sheet, filtering for images that need conversion.
    4. Extract File Details: It processes the retrieved URLs to extract the filename and file extension (JPG, PNG).
    5. Determine Format: A decision node checks if the image is in JPG or PNG format to direct the conversion process accordingly.
    6. Convert Images: Depending on the format, the workflow sends a request to the APYHub API to convert the image to WEBP format.
    7. Update Google Sheet: After conversion, the Google Sheet is updated with the new image URL and marks the original as 'DONE'.
    8. Get Converted File: The converted WEBP image is retrieved for uploading.
    9. Upload to Google Drive: Finally, the converted image is uploaded to a specified folder in Google Drive.

    • Customization Guide

    Users can customize this workflow as follows:
    - API Key: Replace the placeholder API key with your own from APYHub to ensure successful conversions.
    - Google Sheet: Modify the Google Sheets document ID and sheet name to point to your specific sheet containing image URLs.
    - Output Folder: Change the Google Drive folder ID in the upload node to select a different destination for the converted images.
    - Image Formats: If you wish to support additional image formats, edit the logic in the 'JPG or PNG?' node to include those formats and their respective conversion requests.