How do I use the append type of connection?

Description:

Use Append to create a historical record of your data. Append imports or exports the data of a sheet and adds it to the bottom of your previous data.

Example:

For example, use Append to import a sheet that contains three rows of data that you change every single day. Each time you run Append, the latest version of these three rows is imported and added below the data from your previous imports of the days before.

How to use:

  1. Click on the green plus sign
  2. Select Import data
  3. Select Append
  4. Select the source spreadsheet that contains the data you want to append
  5. Select the source sheet inside that spreadsheet that contains the data you want to append
  6. Customize your connection further or directly click on CONNECT to create your connection

This will create a new sheet tab inside your active spreadsheet. Each time you run the connection, it appends the latest data from the source to this sheet.

Have more questions? Submit a request

6 Comments

  • 1
    Avatar
    André Lyra

    Using Append feature in "Export mode", the field "Connection Name" stands for the destiny sheet tab name but that is not what happens when one chooses the second tab and so on. It only reads data from the first tab of the source sheet. 

    Is that a bug or am I misunderstanding?

    Thanks in advance,

    Andre.

    Edited by André Lyra
  • 0
    Avatar
    Robert from Sheetgo

    Dear Andre,

    This is what should happen on export append:

    The name of the connection becomes the name of the new sheet tab inside the destination spreadsheet.

    Yours,

    Robert

  • 0
    Avatar
    André Lyra

    Robert, first of all, thank you for very fast reply.

    I guess I was not too clear about my issue.

    I think it´s about "Source Sheet" field instead. I´d like to be able to export data from the 2nd tab of a sheet of mine to another 1st tab sheet. Every time Import Sheet runs, it reads from the 1st tab of the source sheet, not from the second. It´s ignoring the field "Source Sheet' holding the 2nd tab of the entire source sheet file.

    Thanks in advance again!

  • 0
    Avatar
    Robert from Sheetgo

    Andre,

    Can you please confirm that this is what you want?

    https://youtu.be/Rak6ZbgNULw 

    Yours,

    Robert

  • 0
    Avatar
    André Lyra

    Yep, Robert!

    That is exactly what I want. The only difference is that in my case I am exporting to an already existent tab of destination sheet. I don't know why, but I've just tested the procedure and it's working now. Have you updated something in the system about this?

    Again, I am very thankfull for your time, pacience and support!

    Now I am facing another issue to my export needs. The registries in the destination sheet are modified between two exports, so the second export execution considers nothing about de first and takes all the registries again from de source sheet. Can Import Sheet use some column in the source tab sheet to flag what lines was already syncked in order to not sync them again?

    Andre.

    Edited by André Lyra
  • 0
    Avatar
    Robert from Sheetgo

    Andre, 

    Basically, you are requesting a feature to append only the data that has changed?

    Yours,

    Robert

    :-)

Please sign in to leave a comment.