Stream

Join this community to post or comment

Matthew LaHatt

Questions  - 
 
Can the ImportSheet add-on search Team Drives? If so, does it work now? Or when will it be supported?

I'm working with a client who is in the EAP for Team Drives and loving it. They need to be able rund the add-on and do Import / Export jobs from sheets located inside the Team Drive folders.

When setting up a new Import and I attempt a Search in the Add-on, none of the Team Drive content is coming up in the search results. Only the contents of My Drive.
1
Robert Orzanna's profile photoMatthew LaHatt's profile photo
3 comments
 
That's great news. Thank you +Robert Orzanna and Jonatan!
Add a comment...

Anuj Mittal

Feature Requests: Frequencies & Triggers  - 
 
Hello community,

This add on is amazing. Thanks to the creators :)

Is there any plan to lower the frequency of the trigger? Like instead of every hour, the data can be refreshed every minute?

Thanks,
Anuj
3
Sanjay Mehrotra's profile photoRobert Orzanna's profile photo
9 comments
 
+Sanjay Mehrotra very good point, thank you! I haven't thought about it. We will make sure to keep this in mind, +Jonatan Gomes da Silva.
Add a comment...

Robert Orzanna
owner

Announcements  - 
 
Hello everyone,

For those of you who might have missed it, we added the ability to edit connections in the new interface design. :-)
1
Matthew LaHatt's profile photo
 
I've tested this out a few times. It is working well.
Add a comment...

Robert Orzanna
owner

Announcements  - 
 
Hello all,

I am happy to share with you that you can now finally edit your connections in the new interface. We are sorry that it took us so long but now this crucial feature is alive again. :-)

Yours,

-Robert
1
Add a comment...

Matthew LaHatt

Feature Requests: Other  - 
 
Another "wish" here.

Use two licensing models. One for individuals and another for business.

Your individual user licensing model is great! The prices are good. It works well for small business too.

But you need a second licensing model that supports a single license per domain. Asana, Trello, Slack, and many other tools that are reshaping the business world can tell you this is the way to go. The business pricing model here would need to set a different price points and features than the current single user licenses.

Here's the real life scenario. Small to mid sized companies where they need 12,000 - 20,000 updates per month to keep their data fresh. They've got a 2-5 man team managing / monitoring the Import Sheet jobs around the clock along with the other work they are doing. The current licensing model forces the company to use an additional google license so that everything can run under a service account so that the team can administer it. This service account credentials are then needs shared by the whole team. This sort-of works. But, sharing credentials is not good. Again, not good! Application security models should be secure without the need to share credentials.

Ideally, the company should be able to purchase a single license for their Google @CompanyName.com domain with a three teir licensing model to purchase from. The business licensing model should not be available to users with @gmail.com accounts (exept when invited as a guest).

The first tire. (primary used for POC's)
- Free
- 3-5 users
- 100 updates per month
The second tire.
- $
- 10 users
- 30,000 Updates per month
- view / run / edit rights to Updates set by users.
Enterprise Tier
- $$
- 50 users
- 100,000 or unlimited Updates
- view / run / edit rights to Updates set by users.
- 5 guest accounts (from other domains)

This would greatly help me and a few clients I'm working with now.

1
Chad Pittman's profile photoMatthew LaHatt's profile photo
3 comments
 
"We'll include the plans directly on the pricing page sometime in the future."
- That's really helpful! And will make seeing those licenses easier.

"For data security purposes each connection has only one 'owner' that has rights to edit and delete the connection, but we're rolling out 'transfer connection' feature in the near future so that the connection creator is not necessarily the owner."
- For larger clients, having a SysAdmin role that has rights to all connections is really important. For example, if you've got one of your users who has built a few connections and you find that while they are on PTO for a couple weeks that the connection is breaking something else down the line, the SysAdmin should be able to stop / disable the Update at a minimum. Or if one of your new users build 20 (every hour) connections and starts burning up your quote you need a SysAdmin to step in.
Add a comment...

Matthew LaHatt

Feature Requests: Other  - 
 
For starters, the new UI is great. It looks really good, definitely intuitive, and follows the google UI guide well. Definitely a bit easier to use / understand.

I've got a "Wish" to throw in here. In the attached screenshot the counter needs to show the date the cycle resets. Without it, these number don't mean anything significant. Adding a bit of analytics here would be really helpful. I need to see the percentage of Updates used compared to the percentage of days left in the cycle. For example. Let's say I've used 51% of my updates (mostly scheduled) and I'm 55% of the way through a monthly cycle. In this scenario I am going to run out of updates before the end of the month. In which case, I am going to become an unhappy customer if I find out my data is not moving during the last two few days of the cycle. When a user crosses over the the threshold where the percentage of updates used is greater than the percentage of days left in the cycle this should trigger an alert email / opportunity to notify the customer that they may run out of updates before the end of the month and that they should do one of the following:
A. Upgrade their license.
It would be a great opportunity here to throw in a one time "25% off your next month of service if you upgrade your license right now" to help incentivise us:-)
B. Purchase additional updates at a rate of $.01 per update.
If you leverage a bit of predictive analytics here you can easily estimate the number of updates they will need to complete that month's cycle based off the number of active schedules plus 5% as a buffer and suggest the amount they need to purchase. OR show why there's a cost benefit to upgrade their license and take advantage of the promo now.
1
Robert Orzanna's profile photo
 
Wow, thank you for your elaborate feedback! +Jonatan Gomes da Silva and +Chad Pittman please take note of this, especially "the days left until reset" feature.

Yours,

-Robert
Add a comment...

Phillip Lanos

Questions  - 
 
Hello,
I would like to know if this is possible and how it can be done, I think I came to the right place. I believe you may be some of the best in the biz.

The big idea is that I want to to connect the sum of hours per person from the forecasting sheet and import the data into the scoping sheet.

The challenge is that I would like to be able to scale the data and plan 2 years ahead, potentially.

Therefore I would need the formula to contain a dynamic factor that only looks 3 months ahead and only imports 3 months of data at a time.


This is the formula i've been trying to flesh out but I've hot a roadblock.

=ArrayFormula(QUERY(TRANSPOSE(importrange("1AYQOlzsbNtvrSuYLeKcASES91RRhmvRdaV5Cp_IpQDM","source! A1:BB50")),"Select Row46 where Row1='"&L8&"'"))




Forecast Sheet:
https://docs.google.com/spreadsheets/d/1AYQOlzsbNtvrSuYLeKcASES91RRhmvRdaV5Cp_IpQDM/edit?usp=sharing

Data Destination - Scope:
https://docs.google.com/spreadsheets/d/1EI0fZBocXTlFC8E1nNFBzuo0Wp_bl-VSj7gzZePJVY0/edit?usp=sharing
Drive
Data Destination: ScopeSheet1 Nice Header Client, Month, Expertise, Task, Assigned to, Owner, Estimate, Team, Total Hours Example 1, 12/ 1/ 2016, John Doe, Add hours from" source data" sheet Example 1, 12/ 1/ 2016, Jane Smith Example 1, 12/ 1/ 2016 Example 1, 12/ 1/ 2016 Example 1, 12/ 1/ 2016 Example 1, 12/ 1...
2
Phillip Lanos's profile photoRobert Orzanna's profile photo
3 comments
 
Hi Philip,

Sorry for my late response. Inside two sheets, can you leave me with a comment to better understand where you experience the problem?
Add a comment...

About this community

Import Sheet helps you to connect multiple Google Sheets and Microsoft Excel spreadsheets within your Google Drive to create powerful spreadsheet-based database systems.

Robert Orzanna
owner

Announcements  - 
 
Hello community,

I am happy to share with you that today we released a new version that fixes various problems for Firefox users.

Safari fixes are going to follow tomorrow.

Now you can slowly move back from Google Chrome to your preferred web browsers. :-)

Yours,

-Robert
2
Add a comment...

Robert Orzanna
owner

Announcements  - 
 
Hello community,

Yesterday, I started to create a new video series for you that explains Import Sheet step by step in its entirety.

What you think about it? Would that be useful to you? :-)

Yours,

-Robert
2
Add a comment...

Robert Orzanna
owner

Announcements  - 
 
Hello community,

I am happy to share with you our latest efforts to make documentation accessible in several languages.

Thanks to the great work of +Alexander Ivanov, we already published the Russian and English version. More languages such as German and Turkish are going to follow soon.

We would love more users to help us reduce barriers. If you want to contribute, then please let me know below. :-)

Yours,

-Robert


A short introduction in several languages how to use Import Sheet.
2
Add a comment...

Matthew LaHatt

Feature Requests: Other  - 
 
Another critical wish. It would be really helpful to be able to make copies of Import Sheet jobs.

For example - I have three sheets and a form with multiple Import and Export Updates running between the set. Each sheet serves a different function and has unique formulas, queries, and/or graphs. I have built these sheets and formula's with Import Sheet Updates jobs to serve as a master copy that I want to then share with members of my team. Right now, everyone in my team can make copies of the master sheets easily because they have read rights to the drive folder. However, all the Import Sheet jobs are not visible and don't copy. They have to do a lot of rework to rebuild formulas and Update jobs.

It would great product value increase if there was a way for someone to see Import Sheets jobs of a sheet where they only have read rights. They also need to be able to copy those sheets with the Import Sheet updates intact so they can have their own unique copy without having to rebuild any connections.

Additionally, this would professionally be a big time saver for myself as much of what I'm doing with Import Sheet revolves around a complex core set of sheets with formulas, queries, filters, calculations, and more with Import Sheet Updates. I am manually replicating this set and doing permutations to build out solutions for my clients.

If I could build a complex template and copy it... Golden!
1
Robert Orzanna's profile photo
 
Thank you, Matthew! I will pass this on to Jonatan who manages these requests. I appreciate your level of detail. This will help better prioritise the feature.

Yours,

-Robert
Add a comment...

Matthew LaHatt

Questions  - 
 
In the old Import Sheet UI there was an interface you guys hosted where I could see all my connections. I don't see any links to it in the new UI. Is that coming back? 
1
Matthew LaHatt's profile photoRobert Orzanna's profile photo
3 comments
 
Yes, definitely depending on user demand. Your feedback is a great first step. :-)
Add a comment...

Matthew LaHatt

Feature Requests: Other  - 
 
Import Sheets is amazing! You guys have done such a great job with this add-on.
I've definitely got to put the request for the OnSubmit trigger!
I've now got three clients ready and waiting on trigger so I can build out some powerful business workflow tools for them.

Again, great work. Powerful the tool!
1
Robert Orzanna's profile photoMatthew LaHatt's profile photo
2 comments
 
"On Submit" is really important for every client I'm working with. Really looking forward to seeing this next year.
Add a comment...

nikki diallo

Questions  - 
 
Hey guys how do I install google sheets?



1
Robert Orzanna's profile photo
 
Hello Nikki,

Thank you for your question.

The following link will create a new Google Sheets spreadsheet for you. Remember that you need a Google Account for this to work.

Let me know if it does work:

https://docs.google.com/spreadsheets/create
Add a comment...

Lisa F

Feature Requests: Other  - 
 
hi ... just popped in to say thanks for creating this add on .. it makes things very easy for us!
2
Robert Orzanna's profile photo
 
Hey Lisa,

That's very nice to hear.

Did you already leave your warm words in form of a review in the add-on store?

Thank you and let me know if you need anything else! :-)

-Robert
chrome.google.com - Import Sheet - Google Sheets add-on
Add a comment...