Avatar

Robert Orzanna (Sheetgo)

  • Total activity 325
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 2
  • Subscriptions 170

Activity overview

Latest activity by Robert Orzanna (Sheetgo)
  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How do I structure my data?

    For Sheetgo to work properly it expects well-formatted and structured data. Here are some best practices: The first row should be your header with a description of the columns Row two and onwards ...

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    Automatic updates are not working

    This means that you set an automatic update schedule but your connections don't update automatically. Please try to reset your triggers and see if that solves your problem. To reset your triggers, ...

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How do I use a custom filter view?

    We recommend using a custom filter view instead of a strong filter. If you set a strong filter, then Sheetgo will only import the filtered data. If, however, you set a custom filter view, Sheetgo w...

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How can I help Sheetgo?

    Thanks for your willingness to help Sheetgo! We are a small but dedicated team of 9 people. Hence, all hands and feet are welcome. :-)  Here are some things you can do to help us: Leave a written ...

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How do I find the spreadsheet ID?

    We may ask you for the spreadsheet ID that holds the broken connections. The spreadsheet ID is the string between the /d/ and the /edit. Please take a look at the following example and report back ...

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    Dates in the destination are different from the source

    Please make sure that both the source spreadsheet and the destination spreadsheet use the same timezone setting.

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How can I import formulas?

    We don't currently import formulas but just the raw data. To request this feature, please leave your vote here.

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    What can I do if my automatic updates change dates by one day?

    If your automatic updates are one day off, meaning there is a mismatch between the source and the destination date, make sure your timestamp in the source is not set to 0:00:00. To check and update...

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How do I skip a header row using query?

    You can use query to skip a repeating header row. Please try the following query statement: SELECT * OFFSET 1 If the one does not work, try to experiment with this value, such as choosing -1, 0, or 2.

  • Avatar

    Robert Orzanna (Sheetgo) created an article,

    How do I stop and disable a connection?

    Manual connections don't need to be stopped or disabled because, by definition, they only run whenever you update them manually. To stop and disable automatic connections, please click on the conne...