Loading

Google Drive + Schedule by Zapier + Brex + Formatter by Zapier

Create Google Drive files for Brex card transactions every month

On the first of every month, this Zapier template will export your previous month's Brex card transactions to your Google Drive. It will be a CSV but as a .txt file. Import this file manually into Google Sheets or Excel to see your transactions.

On the first of every month, this Zapier template will export your previous month's Brex card transactions to your Google Drive. It will be a CSV but as a .txt file. Import this file manually into Google Sheets or Excel to see your transactions.

  1. When this happens...
    Schedule by ZapierSchedule by Zapier
    Every Month

    Triggers every month, on the day(s) selected.

    TriggerInstant
  2. automatically do this...
    BrexBrex
    Get Card Transactions

    List Brex Card transactions

    ActionSearch
  3. then do this...
    Formatter by ZapierFormatter by Zapier
    Utilities

    Various utilities like "choose value from list" or "look up in table" (with line-item support).

    ActionWrite
  4. then do this!
    Google DriveGoogle Drive
    Create File From Text

    Create a new file from plain text.

    ActionWrite
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Frequency TypeRequired

    • Interval

    • Start DateRequired

    • Time of DayRequired

    Trigger
    Instant
    Try It
    • Time Offset

    • Trigger on weekends?

    Trigger
    Instant
    Try It
    • Day of the WeekRequired

    • Time of DayRequired

    Trigger
    Instant
    Try It
  • Brex triggers, actions, and search

    Transfer Failed

    Triggers when a transfer has failed

    Trigger
    Instant
    Try It
    • Time of DayRequired

    • Trigger on weekends?

    Trigger
    Instant
    Try It
    • Day of the MonthRequired

    • Time of DayRequired

    Trigger
    Instant
    Try It
  • Brex triggers, actions, and search

    Pending Card Transactions

    Triggers when a card has pending transactions

    Trigger
    Instant
    Try It
  • Brex triggers, actions, and search

    Transfer Processed

    Triggers when an incoming or outgoing transfer has been processed

    Trigger
    Instant
    Try It
google-drive logo
google-drive logo

About Google Drive

Google Drive is Google's file sync app that lets you store all of your files online alongside your Google Docs documents, and keep them synced with all of your devices.
Learn moreHelp

Related categories

  • File Management & Storage
  • Google

Similar apps

Dropbox integrationsDropbox integrations

Dropbox

File Management & Storage
Box integrationsBox integrations

Box

File Management & Storage
OneDrive integrationsOneDrive integrations

OneDrive

File Management & Storage, Microsoft
schedule logo
schedule logo

About Schedule by Zapier

Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.

Related categories

brex logo
brex logo

About Brex

Handle your company’s deposits, payments, credit cards, spend management, and accounting in one place. Brex makes it refreshingly easy to see how your money’s being used and control how it’s spent.

Related categories

formatter logo
formatter logo

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.

Related categories