Automate your crypto community engagement by linking Farcaster casts to Google Sheets, enabling seamless data flow and real‑time analytics. With B3OS, you can trigger sheet updates whenever a cast is posted using Neynar's managed signer, streamlining workflows for developers and creators.
Google Sheets: Add Row
ActionAdd a single row of data to a Google Sheet. Use this to log events, track transactions, or append data to spreadsheets. Provide cell values as an array. Ideal for: transaction logs, event tracking, data collection, audit trails.
Google Sheets: Get Values
ActionRetrieve values from a specific range in a Google Sheet. Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.
Google Sheets: Add Multiple Rows
ActionAdd multiple rows of data to a Google Sheet in a single operation. Use this for batch imports or when you need to write many rows at once. More efficient than adding rows one by one. Ideal for: batch imports, bulk data exports, report generation.
Google Sheets: List Worksheets
ActionList all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Provide the full Google Sheets URL (spreadsheet ID is extracted automatically). Use this to discover available sheets before other Google Sheets actions.
Google Sheets: Update Cell
ActionUpdate a single cell value in a Google Sheet. Use this to modify specific cells, update statuses, change balances, or correct data. Provide the cell reference in A1 notation (e.g., 'B2'). Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Ideal for: status updates, balance tracking, dashboard values, single-field corrections.
Follow Farcaster User
ActionFollow a Farcaster user via Neynar API. Requires a connected Farcaster account with signer. Specify the target user by FID. Ideal for: community growth automation, follow-back workflows, onboarding flows.
