Workflow Guide
Welcome to MARS (Matrix Automated Response System)! This tool helps you plan, create, and publish social media content efficiently. Follow this step-by-step guide to get started.
Configuration
Before running any scripts, ensure your Dashboard settings are complete:
- Client Details: Enter your Client Name and provide a Google Drive link to your Logo.
- Sheet & AI: Paste your Google Sheet URL and OpenAI API Key.
- Facebook: Generate a Page Token to enable auto-posting.
Don't forget to click "Save Configuration"!
Initialize Sheet
Click the Generate Sheet button on the dashboard. This will automatically create the required header columns in your spreadsheet.
Only do this once for a new sheet.
Plan Your Content
Open your Google Sheet and fill in the Topic column (e.g., "Summer Sale", "New Product Launch").
You can optionally fill Caption, Hashtags, or
ImagePrompt manually. If left blank, our AI will generate them for you!
Generate Content & Images
Back on the Dashboard:
- Click Generate Content: The AI reads your topics and writes captions/prompts.
- Click Generate Image: Creates visuals using DALL-E based on the prompts.
Apply Branding
- Embed Logo: Automatically places your Client Logo (from Dashboard) onto the generated images.
- Embed Text: If you added text in the `TextContent` column, this step overlays it onto the image using your configured Font Size.
Publish
Click Post to Facebook.
- Posts can be published immediately or scheduled based on the `PostDate` and `PostTime` columns in your sheet.
- Check the `PostStatus` column in your sheet to see the results!
Terminology & FAQ
| Term | Definition |
|---|---|
| Logo URL | The Google Drive link to your logo file (PNG). Set this in the Client Details tab. |
| Sheet URL | The web address of your Google Spreadsheet. Important: You must share this sheet with the Service Account email (found in your credentials.json). |
| OpenAI Key | Your secret key starting with `sk-...` that allows the system to talk to ChatGPT and DALL-E. |
| Page Token | A secure key that grants this app permission to post on your Facebook Page. Generate this in the Facebook tab. |
Troubleshooting
- "Invalid Arguments" on Schedule: Ensure the server was restarted after recent updates.
- Facebook Token Expired: The system attempts to auto-refresh tokens. If this fails, generate a new User Token via Graph API Explorer and update the configuration.
- Sheet Permission Errors: Ensure your google sheet is shared with "Editor" permissions
- Empty/Missing Cells: The workflow checks for "Complete" status columns. Clear these columns if you wish to re-process a row.