Effortless Image Conversion to WebP with Google Sheets Integration
detail.loadingPreview
Automate the conversion of your JPG and PNG images to the highly efficient WebP format. This workflow seamlessly integrates with Google Sheets, allowing you to manage image sources and update conversion statuses directly.
About This Workflow
This n8n workflow provides a powerful solution for optimizing your web assets by automatically converting images to the WebP format. It leverages the speed and efficiency of WebP to reduce file sizes and improve loading times, essential for modern web performance. The workflow begins by fetching image URLs from a Google Sheet, intelligently determines the original file type (JPG or PNG), and then utilizes the Apyhub API to perform the conversion. Finally, it updates the Google Sheet with the new WebP URL and marks the task as complete. This robust automation streamlines your image management process, saving time and resources.
Key Features
- Automated WebP Conversion: Effortlessly transform JPG and PNG images into WebP format.
- Google Sheets Integration: Fetch image sources and update conversion status directly from your spreadsheets.
- Smart File Type Detection: Automatically identifies JPG/JPEG and PNG formats for accurate conversion.
- API-Powered Efficiency: Utilizes a robust API for reliable and fast image transformations.
- Clear Status Updates: Marks completed conversions in your Google Sheet for easy tracking.
How To Use
- Set up Google Sheets: Create a Google Sheet with columns for 'FROM' (image URL), 'DONE' (to mark completed tasks), and 'row_number'. Populate the 'FROM' column with your image URLs.
- Configure Google Sheets Node: In the 'Get images' node, connect your Google Sheets account and specify your document and sheet name. Set the filter to only retrieve rows where 'DONE' is empty.
- Set API Key: In the 'Set API KEY' node, replace the placeholder 'APY**************************************************************' with your actual API token from Apyhub.
- Define Logic: The 'Get extension' node extracts the filename and extension from the URL. The 'JPG or PNG?' node directs the workflow based on the detected file type.
- Perform Conversion: The 'From JPG to WEBP' and 'PNG to WEBP' nodes make API calls to Apyhub to perform the conversion. Ensure your API key is correctly passed.
- Update Sheet: The 'Update Sheet' node takes the converted image URL (
data) and the original row number to update your Google Sheet, marking the 'DONE' column with an 'x'.
Apps Used
Workflow JSON
{
"id": "911de3b9-40dd-49ed-89aa-fbc7d5501900",
"name": "Effortless Image Conversion to WebP with Google Sheets Integration",
"nodes": 24,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 911de3b9-40dd...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.