?>

SproutVideo + Microsoft Excel Integrations

Appy Pie Connect allows you to automate multiple workflows between SproutVideo and Microsoft Excel

  • No code
  • No Credit Card
  • Lightning Fast Setup
About SproutVideo

SproutVideo is a video hosting platform with strong video marketing, privacy, and analytics solutions that make sharing videos online a breeze.

About Microsoft Excel

Microsoft Excel is an application program for calculations and data management, which generates spreadsheets, and functions as a database. It makes it easier to organize, analyze and present data while helping to make informed business decisions based on the analysis.

Microsoft Excel Integrations
Microsoft Excel Alternatives

Looking for the Microsoft Excel Alternatives? Here is the list of top Microsoft Excel Alternatives

  • Google Sheets Google Sheets
  • Smartsheet Smartsheet

Best ways to Integrate SproutVideo + Microsoft Excel

  • SproutVideo Microsoft Excel

    SproutVideo + Microsoft Excel

    Add Row to Table in Microsoft Excel when Video Deployed is added to sproutvideo Read More...
    Close
    When this happens...
    SproutVideo Video Deployed
     
    Then do this...
    Microsoft Excel Add Row to Table
  • SproutVideo Microsoft Excel

    SproutVideo + Microsoft Excel

    Add Row to Table in Microsoft Excel when List your folders is added to sproutvideo Read More...
    Close
    When this happens...
    SproutVideo List your folders
     
    Then do this...
    Microsoft Excel Add Row to Table
  • SproutVideo Microsoft Excel

    SproutVideo + Microsoft Excel

    Add Row to Table in Microsoft Excel when Video Watched is added to sproutvideo Read More...
    Close
    When this happens...
    SproutVideo Video Watched
     
    Then do this...
    Microsoft Excel Add Row to Table
  • SproutVideo SproutVideo

    Microsoft Excel + SproutVideo

    Update Access Grant in sproutvideo when New Worksheet is created in Microsoft Excel Read More...
    Close
    When this happens...
    SproutVideo New Worksheet
     
    Then do this...
    SproutVideo Update Access Grant
  • SproutVideo SproutVideo

    Microsoft Excel + SproutVideo

    Create Viewer Login to sproutvideo from New Worksheet in Microsoft Excel Read More...
    Close
    When this happens...
    SproutVideo New Worksheet
     
    Then do this...
    SproutVideo Create Viewer Login
  • SproutVideo {{item.actionAppName}}

    SproutVideo + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} {{item.actionTitle}}
Connect SproutVideo + Microsoft Excel in easier way

It's easy to connect SproutVideo + Microsoft Excel without coding knowledge. Start creating your own business flow.

    Triggers
  • List your folders

    Folders are a great way to organize videos in a hierarchical way within your account. Folders can contain both videos and other folders.

  • Video Deployed

    Triggers when a new video has been deployed within your account.

  • Video Watched

    Triggers when a video has been watched

  • New Row in Table

    Triggers when a new row is added to a table in a spreadsheet.

  • New Worksheet

    Triggers when a new worksheet is added to a spreadsheet.

    Actions
  • Create Access Grant

    Create a new access grant within your sproutvideo account.

  • Create Folder

    Create a new folder within your SproutVideo account.

  • Create Viewer Login

    Create a new viewer login within your SproutVideo account.

  • Update Access Grant

    Updates the settings for an existing access grant in your SproutVideo account.

  • Upload Video

    Uploads a video to your SproutVideo account.

  • Add Row to Table

    Adds a new row to the end of a specific table.

How SproutVideo & Microsoft Excel Integrations Work

  1. Step 1: Choose SproutVideo as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Microsoft Excel as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from SproutVideo to Microsoft Excel.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of SproutVideo and Microsoft Excel

SproutVideo

SproutVideo is an online video platform that allows users to host, manage, and share their videos. From the website. “SproutVideo is a fully-hosted cloud-based service that empowers businesses, organizations, publishers and individuals to create, manage, monetize and distribute quality video.” (SproutVideo.com. Businesses can use SproutVideo for internal communication, customer support and training, and product demos.

Microsoft Excel

Microsoft Excel is a program that assists users in creating spreadsheets or tables. From the website. “Create and save spreadsheets with ease, and access them from virtually any device to work on them together with others or on your own.” (Microsoft.com. Microsoft Excel allows for business analysis of all types of data. It can be used for analysis of financial information, compliance requirements, human resources data, operational data, and more. For the purpose of this article, we will examine how Microsoft Excel can be used in combination with SproutVideo to analyze promotional costs and returns.

Integration of SproutVideo and Microsoft Excel

To begin our integration of SproutVideo and Microsoft Excel, we will open Microsoft Excel to create a new spreadsheet. Choose the template you wish to use based on the data that you want to analyze. In this example, we will use the “Totals” template because we are interested in calculating the total sales revenue per region. Once you have chosen your template, a window will pop up asking you to name your spreadsheet. You may choose what you like but I suggest naming it something relevant such as “XYZ Sales Revenue.”

Now that our spreadsheet is created, let’s populate it with some data. To do this, we will add a “Data” tab in the ribbon which can be found by clicking on the tab with the icon of a piece of paper.(Figure 1)

Figure 1. Ribbon Designating Data Tab

This will open up a blank area where we will add our data. We will start with adding the title at the top of the spreadsheet (Figure 2. To do this click in cell A1 and type your desired title. Figure 2. Title Added At Top of Spreadsheet (A1)

Next, we will add the cells where we will enter our data into. To do this click on cell B2 and drag down to cell B5. This will include cells B2 through B5 in our spreadsheet (Figure 3. Figure 3. Entire Spreadsheet (B2-B5)

Now that we have added our cpumns for our data to go into we will add the cells where we wish to put our formulas. We will look at two methods of doing this. The first method is by using the formula bar at the bottom of the spreadsheet (Figure 4. Figure 4. Formula Bar Located at Bottom of Spreadsheet

The second method invpves right clicking on the cell where you wish to insert your formula and choosing “Insert Function” (Figure 5. Figure 5. Right Clicking on Cell Allows for Function Insertion

If you choose to use the formula bar at the bottom of the spreadsheet then your formula would look like this. =SUM(B2:B5. where B2-B5 are the cells you have already been creating in your spreadsheet. If you choose to use the “Insert Function” option then your formula would look like this. =SUM(B2:B5. where B2-B5 are the cells you have already been creating in your spreadsheet. If you choose to use the “Insert Function” option then your formula would look like this. =SUM(B2:B5)

Once you have finished entering all your formulas, it is time to test drive your newly created spreadsheet! To do this simply click on cell A1 and move over to cell B1 (Figure 6. Figure 6. Using Cells A1 and B1 as an Input/Output Area

After clicking on cell B1 you should see a total number appear in cell A1 (Figure 7. Figure 7. Number Appearing in Cell A1

Now let’s test out another function! Let’s say you want to find out how many units were spd in each region. To do this we will first highlight cells B2 through B5 (Figure 8. Figure 8. Highlighting Cells B2 through B5

Once we have highlighted these cells we will open up the “Formulas” tab on the ribbon (Figure 9. Figure 9. Opening Formulas Tab on Ribbon

From here we will click on “Name Manager” (Figure 10. Figure 10. Name Manager Located in Formulas Tab on Ribbon

From here we will click on “Define Name” (Figure 11. Figure 11. Define Name Button Located in Name Manager

Once you click on “Define Name” you will see a box appear where you can name your variable (Figure 12. Figure 12. Naming Your Variable in Name Manager

After naming your variable you will be asked to insert your variable into your spreadsheet (Figure 13. Figure 13. Inserting Your Variable into Your Spreadsheet

You should now see your variable listed in your Name Manager (Figure 14. Figure 14. Variable Now Listed in Name Manager

From here, click on cell C2 and drag down to C5 (Figure 15. Figure 15. Cells C2-C5 Selected On Your Spreadsheet

Now fill in your variables into cells C2-C5 (Figure 16. Figure 16. Variables From Cells B2-B5 Now Present in Cells C2-C5

Now that you have filled in your variables it's time to test out our spreadsheet again! Move back over to cell A1 and enter in cell A1 =Sales_Count(C2. where C2 is replaced by one of our variables from cells C2-C5 (Figure 17. Figure 17. Cell A1 Now Populated By Cell C2

The process to integrate SproutVideo and Microsoft Excel may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.