Microsoft Excel + ProAbono Integrations

How to connect Microsoft Excel + ProAbono

Zapier lets you send info between Microsoft Excel and ProAbono automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Connect Apps

Connect My Apps

Free forever for core features
14 day trial for premium features & apps

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

Supported triggers and actions

What does this mean?

- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- Folder
  NOTE that this defaults to the root of the drive.
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- Folder
  NOTE that this defaults to the root of the drive.
- TitleRequired
- Column Headers
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.
- Lookup ValueRequired
Action
Search

- Event Type related to a credit noteRequired
Trigger
Instant
Try It
- Event Type related to an invoiceRequired
Trigger
Instant
Try It

- Event Type related to a subscriptionRequired
Trigger
Instant
Try It
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
- Ensure Billable ?
  If True forces the verification of the payment information, even if the Offer is free. If the customer has not registered any payment information, the 403 forbidden error is returned.
- Date Start
  Ignore what's before that date.
- Date End
  Ignore what's after that date.
- Force Offline ?
  If true, it forces the invoice to be offline for a customer with automated payment (card, direct debit).
- Note
  A note is added to the bottom of an invoice PDF, just above the Customer Service Section.
Action
Write
- NameRequired
- EmailRequired
- Reference CustomerRequired
  The unique identifier used within your own application for this customer.
- Language
  Language of your customer. See all Language Codes.
- Reference Affiliation
  This field helps you to add information of affiliation to the Customer. For example, you can add an ip address, a name of a reseller, ...
- Segment
Action
Write
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
Action
Write
- Reference CustomerRequired
Action
Write
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
Action
Write
- Subscription IdRequired
  Id of the subscription to suspend.
Action
Write
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
- Company
- First Name
- Last Name
- Address Line 1
- Address Line 2
- Zip Code
- City
- Country
  Country Code ISO 3166-1 Alpha-2 code (ie Country Code in 2 letters)
- Region/State/Province
  Region/State/Province Code ISO 3166-2. Ex : For the State of Delaware in the USA - the region code is: US-DE.
- Tax Information
  i.e. VAT number (english), numéro de TVA Intracommunautaire, (français), ..
- Phone
Action
Write
- Subscription IdRequired
  Id of the Subscription.
- OfferRequired
  The Subscription will be upgraded to this Offer.
- When should this upgrade be applied ?Required
  Usually an upgrade is applied right away but sometimes you need to wait the end of the current term to applied it.
- Should The Minimum Commitment be ignored ?Required
  Some subscriptions can NOT be upgraded because of their commitments. Ex : a monthly subscription with 12 months commitment can not upgrade within the first 12 months.
- When Should this upgrade be billed ?Required
  The upgrade can be billed right away OR at the next renewal (ie at the end of the current term.)
Action
Write

- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
  Trigger on changes to cells in this column only.
Trigger
Scheduled
Try It
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  We will only update columns you provide, leaving all others untouched.
Action
Write
- Storage Source
  NOTE that this defaults to OneDrive. If Sharepoint is picked, subsequent folders that would be listed are ONLY folders in the default Sharepoint site. Other custom Sharepoint sites are currently not supported.
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.
- Lookup ValueRequired
Action
Search or write
- Event Type related to a customerRequired
Trigger
Instant
Try It
- Event Type related to a payment method (bank card and/or direct debit mandate)Required
Trigger
Instant
Try It
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
Action
Write
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
- LabelRequired
  Label of the Line which will be displayed in the invoice.
- AmountRequired
  The Amount must be in cents (127.97 € -> 12797) and before taxes .
- Quantity
  Quantity is purely informative and will be displayed in the invoice.
- Should the line be created only if the customer has valid payment information ?Required
Action
Write
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
- OfferRequired
- Start Date
  Set the Date when the Subscription will start. If not provided, the Subscription starts immediately.
- Title
  Override the Title of the Offer. By Default, the Title of the new Subscription is copied from the Offer.
- Description
  Override the Description of the Offer. By Default, the Description of the new Subscription is copied from the Offer.
- UpFront Fee
  Override the UpFront Fee (aka Setup Fee) of the Offer. Amount must in cents (127.97 € -> 12797).
- Recurring Amount
  Override the Recurring Amount of the Offer. Amount is in cents (592.97 € -> 59297).
- Termination Fee
  Override the Termination fee of the Offer. Amount is in cents (90.00 € -> 9000).
Action
Write
- Credit Note IdRequired
  The number of a credit note like "FA001-000000023" is not the credit note Id. Credit Note Id is an unique internal identifier.
Action
Write
- Invoice Id
  The number of an invoice like "F001-000000023" is not the Invoice Id. Invoice Id is an unique internal identifier.
Action
Write
- Subscription IdRequired
  Id of the Subscription to start.
Action
Write
- Subscription IdRequired
  Id of the Subscription to terminate.
- When should this termination be applied ?Required
  Usually a termination is applied at the end of the current term but sometimes you need to applied right away and not wait.
Action
Write
- Reference CustomerRequired
  Reference of the Customer shared by the application and ProAbono.
- How the Customer will pay futures invoices created in ProAbono ?
  Choose a payment type only if the customer does NOT pay by bank/debit/credit card or SEPA direct debit.
- Next Billing Date
  Update the Next Billing Date of the Customer.
- Should the customer be automatically billed on each term ?
  By default, in ProAbono, each customer is billed automatically according its subscription(s).
Action
Write
- Country NameRequired
  Search by country name. English ONLY.
Action
Search

How Microsoft Excel + ProAbono Integrations Work

Step 1: Authenticate Microsoft Excel and ProAbono.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Microsoft Excel + ProAbono

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About ProAbono

Subscription Billing Made Easy. Subscription Billing As-a-Service, for the New Generation of Services.

Related categories

Payment Processing

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Microsoft Excel + ProAbono Integrations

How to connect Microsoft Excel + ProAbono

Connect your apps and automate workflows

New Row

Storage Source

SpreadsheetRequired

WorksheetRequired

New Worksheet

Storage Source

Folder

SpreadsheetRequired

Add Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

Storage Source

Folder

TitleRequired

Column Headers

Find Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Event(s) Related to a Credit Note

Event Type related to a credit noteRequired

Event(s) Related to an Invoice

Event Type related to an invoiceRequired

Event(s) Related to a Subscription

Event Type related to a subscriptionRequired

Bill a Customer

Reference CustomerRequired

Ensure Billable ?

Date Start

Date End

Force Offline ?

Note

Create or Update a Customer

NameRequired

EmailRequired

Reference CustomerRequired

Language

Reference Affiliation

Segment

Retrieve Billing Address of a Customer

Reference CustomerRequired

Retrieve a Customer

Reference CustomerRequired

Retrieve Payment Settings of a Customer

Reference CustomerRequired

Suspend a Subscription

Subscription IdRequired

Update Billing Address of a Customer

Reference CustomerRequired

Company

First Name

Last Name

Address Line 1

Address Line 2

Zip Code

City

Country

Region/State/Province

Tax Information

Phone

Upgrade a Subscription

Subscription IdRequired

OfferRequired

When should this upgrade be applied ?Required

Should The Minimum Commitment be ignored ?Required

When Should this upgrade be billed ?Required

New Row in Table

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired