Spreadsheet: 887457d1737682316-multiple-conditions-based-on-rules-multiple-conditions-based-on-rules
Sheet: 1 de cada (4) ING

 | Message | Rule 1 | Rule 2 | Rule 3 | Rule 4 | Rule 5
 | Notification Text: Compra aprovada de R$ 38,99 - CROISSANT E CIA SBC para JULIA DE SOUZA INAC em 13/11/2024, às 15:55, no PERSON BLACK PONTOS . | JULIA DE SOUZA INAC | aprovada | compra | 38.99 | CROISSANT E CIA SBC
Examples | Message database | Rule 1 | Rule 2 | Rule 3 | Rule 4 | Rule 5 |  | Rule 1 | Rule 2 | Rule 3 | Rule 4 | Rule 5
Example A | Notification Text: Compra aprovada de R$ 38,99 - CROISSANT E CIA SBC para JULIA DE SOUZA INAC em 13/11/2024, às 15:55, no PERSON BLACK PONTOS . | Extract the word between the word "para"  AND "em" | If contains the word "aprovada", copy it to this cell | If contains the word "compra", copy it to this cell | Extract the word between the word "R$" AND "-" | Extract the word between the word "-"  AND "para" |  | JULIA DE SOUZA INAC | aprovada | compra | 38.99 | CROISSANT E CIA SBC
Example B | Notification Text: Itau Personnalite: Ola, compra presencial aprovada de R$ 106,50, no seu cartao final 6010 em RONALDOFERRE0712. [NAME] seu extrato no aplicativo. | Extract the word between the word  "final" AND "em" | If contains the word "presencial", copy it to this cell | If contains the word "compra", copy it to this cell | Extract the word between the word "R$" AND 3rd "," | Extract the word between the word "em" AND "." |  | 6010 | presencial | compra | 106.5 | RONALDOFERRE0712
Example C | Notification Text: Compra aprovada de R$ 179,99 - ECOMMERCE OL*Olympikus em 29/11, às 22:20, no seu PERSON BLACK PONTOS final 6865. 👍 | Extract the word between the word "final" AND "." | If contains the word "aprovada", copy it to this cell | If contains the word "compra", copy it to this cell | Extract the word between the word "R$" AND "-" | Extract the word between the word "-"  AND "em" |  | 6865 | aprovada | compra | 179.99 | ECOMMERCE OL*Olympikus
Example D | Notification Text: Compra aprovada no seu PERSON VS INFINITE final 0798 - ALLIANZ SEGUROS S/A valor RS 149,17 em 15/12, as 02h09. | Extract the word between the word  "final"  AND "-" | If contains the word "aprovada", copy it to this cell | If contains the word "compra", copy it to this cell | Extract the word between the word "RS" AND "em" | Extract the word between the word "-"  AND "valor" |  | 798 | aprovada | compra | 149.17 | ALLIANZ SEGUROS S/A
Example E | Notification Text: Compra no cartão final 8462, de R$ 49,90, em 12/12/24, às 11:15, em APPLE.COM.BILL, aprovada. | Extract the word between the word  "final" AND "," | If contains the word "aprovada", copy it to this cell | If contains the word "compra", copy it to this cell | Extract the word between the word "R$" AND "em" | Extract the word between the word "em" AND "," |  | 8462 | aprovada | compra | 49.9 | APPLE.COM.BILL
Example F | Notification Text: Compra de US$ 0,86 realizada com sucesso. | N/A | If contains the word "US$", copy to this cell | If contains the word "compra", copy it to this cell | Extract the word between the word "US$" AND "realizada" | N/A |  |  | US$ | compra | 0.86
Example G | Notification Text: [NAME] o pagamento de SANTANDER SANTANDER ELITE no valor de R$ 272,59 para 19/12/24. | N/A | If contains the word "pagamento", copy it to this cell | If contains the word "pagamento", copy it to this cell | Extract the word between the word "R$" AND "para" | Extract the word between the word "de" AND "no" |  |  | Pagamento | Pagamento | 272.59 | SANTANDER SANTANDER ELITE
Example H | Notification Text: Agradecemos o pagamento de RS 655,21 efetuado em 02/12/2024 para PERSON VS INFINITE. Em breve estara disponivel [NAME] no APP. | N/A | If contains the word "pagamento", copy it to this cell | If contains the word "pagamento", copy it to this cell | Extract the word between the word "RS" AND "efetuado" | Extract the word between the word "para" AND "." |  |  | Pagamento | Pagamento | 655.21 | PERSON VS INFINITE
Example I | Notification Text: O pagamento do boleto de SISTEMA EDUCACIONAL SINGU no valor de R$ 1.625,02 já foi realizado. Você pode consultar no seu extrato. | N/A | If contains the word "boleto", copy it to this cell | If contains the word "pagamento", copy it to this cell | Extract the word between the word "R$" AND "já" | Extract the word between the word "de" AND "no" |  |  | Boleto | Pagamento | 1625.02 | SISTEMA EDUCACIONAL SINGU
Example J | Notification Text: Você fez um Pix para BK BRASIL OPERACAO, 13.574.594/0001.96, para MERCADO PAGO IP LTDA., no valor de R$ 9,50 em 15/11/2024. | N/A | If contains the word "PIX", copy it to this cell | If contains the word "Fez", copy it to this cell | Extract the word between the word "R$" AND "em" | Extract the word between the word "para" AND "," |  |  | PIX | Fez | 9.5 | BK BRASIL OPERACAO
Example K | Notification Text: Você recebeu um Pix de MANUELA XXX.611.338-XX do(a) [NAME], no valor de R$ 48,00 em 26/11/2024. Pix para [NAME] | N/A | If contains the word "PIX", copy it to this cell | If contains the word "[NAME]", copy it to this cell | Extract the word between the word "R$" AND "em" | Extract the word between the word "de" AND "do" |  |  | PIX | Recebeu | 48 | MANUELA XXX.611.338-XX do(a) [NAME]
Example L | Notification Text: Olá, você recebeu uma [NAME] no valor de R$ 3.420,00 em 03/12/2024 | N/A | If contains the word "[NAME]", copy it to this cell | If contains the word "[NAME]", copy it to this cell | Extract the word between the word "R$" AND "em" | Extract the word between the word "de" AND "no" |  |  | [NAME] | Recebeu | 3420 | [NAME]
Example M | Notification Text: Você fez uma transferência para Sistema no valor de R$ 1.670,41 em 17/01/2025. | N/A | If contains the word "[NAME]", copy it to this cell | If contains the word "Fez", copy it to this cell | Extract the word between the word "R$" AND "em" | Extract the word between the word "para" AND "no" |  |  | [NAME] | Fez | 19670.41 | Sistema
Example N
Example O
 | Assumptions
 | Items highlighted in blue ones (at collumn B) are variable and will change every time a new message is received
 | Flexibility to include new messages format into "message database"--> new messages format will demand new rules adjustment