
Other popular Google Sheets workflows and automations
-
Put all your completed tasks in a Google Spreadsheet
-
All your new reminders in one Google Drive spreadsheet
-
Log new items in Raindrop.io to a Google Sheet
-
Add new Square payments to a spreadsheet
-
Add row to Google Sheets using MESH
-
Keep a log of your recently played tracks
-
Automatically log every call you make on your Android phone to a Google spreadsheet
-
Automatically log work hours in a spreadsheet
-
Log motion from Ring into Google Drive

Create your own Google Sheets and GoodWe SemsPortal workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
14 triggers, queries, and actions
How to connect to a Google Sheets automation
Find an automation using Google Sheets
Find an automation to connect to, or create your own!Connect IFTTT to your Google Sheets account
Securely connect the Applet services to your respective accounts.Finalize and customize your Applet
Review trigger and action settings, and click connect. Simple as that!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
More on Discord and Instagram
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About GoodWe SemsPortal
This service enables you to create your home automation based on the metrics from your GoodWe inverter. It periodically reads new data from SemsPortal and fires triggers when defined limits are reached.
By using metrics like Pmeter (W), Power (W) or SOC (%) you can trigger actions when your PV starts/stops providing enough excess solar energy or when your battery is charged/drained.
Tip: Combine these triggers with an electric heater or a mobile air conditioning unit in a smart plug to effectively get a watt router without the need for additional devices!
Important: The triggers fire 'on the edge', not 'on the level'. This means that for example the trigger "PV metric exceeds a limit" fires only when the value goes from below the limit to above the limit. It then does not fire until the value drops below and exceeds the limit again.
Future plans: Currently the service polls SemsPortal for new data every 5 minutes (no matter what IFTTT plan you have). However, your GoodWe inverter provides new data every single minute. So that you can get the most out of your inverter, we are planning to increase the download frequency to one minute as part of a subscription. Press the Visit button below for more details.
This service enables you to create your home automation based on the metrics from your GoodWe inverter. It periodically reads new data from SemsPortal and fires triggers when defined limits are reached.
By using metrics like Pmeter (W), Power (W) or SOC (%) you can trigger actions when your PV starts/stops providing enough excess solar energy or when your battery is charged/drained.
Tip: Combine these triggers with an electric heater or a mobile air conditioning unit in a smart plug to effectively get a watt router without the need for additional devices!
Important: The triggers fire 'on the edge', not 'on the level'. This means that for example the trigger "PV metric exceeds a limit" fires only when the value goes from below the limit to above the limit. It then does not fire until the value drops below and exceeds the limit again.
Future plans: Currently the service polls SemsPortal for new data every 5 minutes (no matter what IFTTT plan you have). However, your GoodWe inverter provides new data every single minute. So that you can get the most out of your inverter, we are planning to increase the download frequency to one minute as part of a subscription. Press the Visit button below for more details.