lme-auto-messenger

What This Skill Does

The lme-auto-messenger skill is a sophisticated automation tool designed to bridge the gap between Google Sheets customer databases and LINE Official Account (LME) messaging. It streamlines the lifecycle of customer engagement by periodically reading spreadsheet data, evaluating user interests based on custom category flags (such as 'interested', 'not interested', or 'pending'), and executing personalized messaging via Browser Relay. By automating this, businesses can maintain consistent contact without manual overhead, ensuring that personalized messages reach customers at the right time.

Installation

To integrate this capability into your workflow, ensure you have the OpenClaw CLI configured. Run the following command in your terminal: clawhub install openclaw/skills/skills/aoaibiz/lme-auto-messenger Once installed, verify that you have authenticated your Google Workspace environment using gws auth login and that your Browser Relay session is active for the Chrome profile where you manage your LME account. Configuration of the target spreadsheet structure (A-G columns as specified in documentation) is required before the first execution.

Use Cases

This skill is perfect for lead nurturing programs. For example, if a user marks a prospect as interested in a specific product category within your Google Sheet, the agent can trigger a personalized, pre-configured message to that customer via LME. It is also highly effective for re-engagement campaigns, where the agent identifies customers who have not interacted recently, allowing for automated follow-up messages. It is ideal for marketing teams aiming to scale personalized customer service without expanding their workforce.

Example Prompts

1. "Check the latest spreadsheet entries for any customers with '○' in the 'Product-X' category and send them the personalized follow-up template A via LME."
2. "Scan the current sheet for inactive leads marked as '△' and draft a polite re-engagement message, but wait for my approval before sending."
3. "Analyze the last 50 rows of my customer sheet and prepare a summary report of interest levels per category, then output the data for manual review."

Tips & Limitations

Always ensure that the spreadsheet headers match the exact format to avoid parsing errors. Because this skill interacts with external communication platforms, monitor your message volume closely to avoid being flagged for spam by LINE. Keep your message templates varied to maintain high engagement rates. Remember that the skill relies on Browser Relay, so if your LME session expires, you must re-authenticate in the browser before the skill can proceed.