Ok, took a bit longer but have a much cleaner solution. Format Functions in CB Auto Actions now support inline Query and Code execution (must be a Super User to toggle on and use these!). This allows substantially easier inserting of the invoice HTML wherever you like in whatever auto action you like. The below for example will example the invoice HTML. Note you'll need to update to latest CB Auto Actions build release before you can utilize this.

Global
Triggers: onCPayAfterPaymentStatusChange
Type: Email
User: Automatic
Access: Everybody
Conditions
Field: Custom > Value
Custom Value: [var4]
Operator: Equal To
Value: Completed
Action
Subject: Invoice
Body: Parameters
Format Functions: Yes
Format Code Function: Yes

The complicate comes from determining if the basket contains merchandise payments or not. This would apply to all baskets basically. So to find if a merchandise was purchased it'll require an additional condition that checks what is in the basket. The below should work for that.

Field: Code
Custom Code: Operator: Equal To
Value: 1

This should allow the condition to match if the basket contains at least 1 row item that's a merchandise.

Your conditions are probably is what is failing. The database state is considered in transit. It can change based off webhooks, what state they're moving into/from, etc..

Are you needing to act on the payment status change or the subscription status change? onCPayAfterPaymentStatusChange is the correct trigger for payment status changes and onCPayUserStateChange is the correct trigger for subscription status changes. With both you should be using the variables already provided to them instead of querying for information. After selecting either trigger you should see what variables are available to them just below the Triggers parameter.

Since you mentioned payment being finalized and subscription being active I'd act on subscription state change with onCPayUserStateChange. The below for example should work fine.

Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: A
Condition 2
Field: Custom > Code
Code: Operator: Equal To
Value: YOUR_PAYPAL_GATEWAY_ID_HERE

This will work on renewals as well. If you only want it on first payment you'll need to add a condition against the $reason. Example as follows.

Field: Custom > Value
Custom Value: [var6]
Operator: Not Equal To
Value: R

That should be doable since the option selection is stored with the basket, the subscription, and POST data so it's possible to pull that value from either in CB Auto Actions. The main issue will be how you've defaults setup. You'd need to have admin approval enabled by default in CB > Configuration > Registration so that you're turning it off rather than on.

As for what trigger to act on. Probably best to do this the same way CBSubs does. Directly before registration is completed. So the onCPayBeforeUserRegistration trigger should work here. It has limited information in it as follows.

Basically only have the array of plans selected in addition to the user being registered. So this is doable, but it will take PHP experience as you'll be overriding the registration behavior of CBSubs. For example the below will force the registration approved, but needs additional checks like checking the option selection from POST data.

Global
Triggers: onCPayBeforeUserRegistration
Type: Code
User: Automatic
Access: Everybody
Action
Method: PHP
Code: Output
Display: return

The only way to conditionally display content like that is with substitutions. You won't be able to do this from CB Content Module because it has no user to act on since they're not logged in.

The best I can suggest is to just replace the confirmation page entirely and redirect them away to language specific pages. That is doable with CB Auto Actions. The below should work.

Global
Triggers: onAfterUserConfirmation
Type: Redirect
User: Automatic
Access: Everybody
Conditions
Condition 1
Field: Custom > Value
Custom Value: [confirmed]
Operator: Equal To
Value: 1
Condition 2
Field: Custom > Value
Custom Value: [cb_country]
Operator: Equal To
Value: DE
Condition 3
Field: Custom > Value
Custom Value: [cb_gender]
Operator: Equal To
Value: female
Action
URL: YOUR_ARTICLE_URL_HERE

Replace YOUR_ARTICLE_URL_HERE with your language specific article so you can display whatever language specific content you want. I don't know how you're handling age so I didn't add that condition so you'll need to add that yourself.

I suppose another option is to auto login after confirmation. CB Auto Actions includes a system action for this already, but it requires their account to be fully confirmed and approved before it'll auto login. Then you could display whatever you like since they'll be logged in.

Probably the easiest option is to just loop through the user messages and pass them through substitutions so you can just use substitutions in the language override. The below should work.

Global
Triggers: onAfterUserConfirmation
Type: Code
User: Automatic
Access: Everybody
Action
Method: PHP
Code: Parameters
Reference Variables: Variable 5

Now all you should need to do is user language overrides and add your substitutions to the confirmation message strings.

There's a trigger for confirmations. onAfterUserConfirm and onAfterUserConfirmation are both usable. The first one fires for backend and frontend. The second one fires for frontend confirmation link only. So your usage would be something like the below.

Global
Triggers: onAfterUserConfirm
Type: CB Paid Subscriptions
User: Query
Access: All Registered Users
User Conditions
Field: Custom > Value
Custom Value: [var2]
Operator: Equal To
Value: 1
Field: Custom > Query
Custom Query: Operator: Greater Than or Equal To
Value: 3
Action
Mode: Subscribe
Plans: YOUR_PLAN_HERE

This should find the user that invited the user being confirmed and set them into the auto actions user object. Next it checks [var2], which for this trigger is $state (should be noted under Global tab) and is the confirmation state. So it checks that confirmation state is set to 1 for confirmed. Finally we check how many accepted invites the user has (this will be the user that send the invite) by counting them and conditioning against the count. Finally add the subscription to the user who sent the invite.

I still have the Like and Comment settings enabled under Activity > Article. Should I also move those to Auto Actions?

Do you need those activity? and do you need them to also have that flair?

I’m now realizing just how versatile Auto Actions is, but it has always seemed to have a steep learning curve. I remember you once said that creating detailed documentation isn’t possible, but that you’re ready to help prepare solutions — and I see you doing that in other threads too. Maybe collecting those ready-made solutions with some basic categorization in one place could help people like me better understand the tool and take advantage of its full potential?

The complexity in it is you need to have some understanding of what triggers you need and the variables those triggers provide. I've improved things a good bit as it now has a variable output for selected triggers just below the triggers parameter. Generally each persons usage is different from one another; especially conditions. I provide examples using the same format I did above so you're welcome to search our forums for them.

if article tags have the same names as flairs, could we automatically assign those corresponding flairs to the activity during its creation?

That might be doable. Will add a feature ticket and review when I have further time as I really need to get back to CB Gallery 3.0 or it's never going to get done, lol.

forge.joomlapolis.com/issues/9719

Since ActivityEntity has been extended with these features you can probably use the core activity logging functionality and instead just use CB Auto Action to extend those activity. This requires some PHP, but the below should probably work.

Global
Triggers: activity_onBeforeActivityEntitySave
Type: Code
User: Self
Access: Automatic
Action
Method: PHP
Code:
Replace COMMA_LIST_OF_FLAIR_IDS as the name implies with a comma list of flair ids. You can find flair id within CB Activity > Flair as the far right column. This would avoid you having to make your own create, comment, and like activity auto actions and would only need this.

Ok, managed to get both done today. Below is an auto action for article create.

Global
Triggers: onContentAfterSave
Type: CB Activity
Access: Everybody
User: Automatic
Conditions
Field: Custom > Value
Custom Value: [var1]
Operator: Equal To
Value: com_content.article
Action
Mode: Activity
Method: Create
Published: [var2_state]
Asset: article.[var2_id]
Owner: [var2_created_by]
Comments: Articles
Likes Asset: article.[var2_id]
Date: [var2_created]
Load By: By Asset Only

That should work for when you save an article to save the same way the core activity does. Adjust the other features as needed. Once you've updated both CB Activity and CB Auto Actions you should have a new parameter there called Flair to select what flair you want applied. Short codes in the Message parameter are also functional and documented in its parameter description.

Be sure to turn off the parameter in CB Activity for logging article activity though since that won't be necessary now.