I have purchased power tools as I am using it for most of my tasks in work. After purchasing, i got an activation key but after copy and pasting it to activation, it says invalid or wrong code. Then now, power tools is now unable to install on my google spreadsheet. Tried several uninstall and install but still the same.
Thank you for the comment. Sorry for the difficulties with installation, there's some problem on the Google side that's directly impacting all Workspace add-ons. The issue has occurred only today, and our team is actively investigating it.
The problem has already been reported to Google, so please follow the link and click "+1" at the upper right corner. It will let Google know how many people are affected.
Regarding your activation key, please email us at firstname.lastname@example.org with your key, we will check it in our database and see what we can do.
I can't seem to install the count by color tool, nor the power tools. After asking permission with my gmailaccountname and password, it says 'this webpage is not available', too many redirects and also a 404 page afterwards.
Please send the screenshot of the error message to email@example.com. We will help asap.
Hello support team,
I've made a purchase on 3/1/2023 for 29.95$. The money were withdrawn from my visa but afterwards I received the note: " Your purchase was declined. Please, enter correct visa number". Since then neither money was returned, nor tool access provided.
Please, get back to me asap.
Thank you for your message. Sorry to hear that you're having difficulties with the purchase.
For us to be able to help you better, please send us any proof of the charge withdrawn from your card at firstname.lastname@example.org. If you've got an order number when making the purchase, please send it to us as well. We'll contact our e-commerce service 2Checkout to clarify the issue. Thank you.
Hello, I do not want to give access to my whole Google Drive. I want to limit the tools' access to only the spreadsheets that I need it for. How can I limit the access?
I will reconfirm if it is possible to limit the access with our developers. Yet, please read more about the permissions required by the tool here:
Hello there Power Tools for Google Sheets is running slow today 1/10/23. Just letting you know this is an issues with multiple colleagues reporting the same thing. Thanks
Thank you for letting us know, Charles.
I've downloaded Power Tools 30 day trial and it shows in Extensions but is faded and will not let me click on.
Thank you for your comment. Sorry to hear you've faced difficulties of this kind with our add-on.
Please note that there is currently an issue on the side of Google that occurs when you are logged in under more than one account. Please sign out and log back in only under the account you used to grant permissions to the add-on and see if the issue persists.
If this doesn't help, please email us at email@example.com.
I constantly get the message to purchase this on my screen EVERY time I open GD and files. I do not want this to pop up everytime and I can't figure out how to get rid of it. Help.
Thank you for your message. Please Unpin the add-on by clicking on the corresponding icon at the bottom of the add-on's pane to disable auto-start. Thank you.
Is there a way to use the Power Tools in a macro?
Also, do you have a Power Tool that forces google sheets to refresh the ENTIRE sheet, not just TIME, DATE, etc. ?
Thank you for your questions.
I'm sorry but our add-on can't be run from a macro.
However, please note that there are scenarios available for Remove Duplicate Rows, Compare Sheets, Combine Duplicate Rows and Merge Sheets: you can save the settings you use most often into scenarios and run them in a couple of clicks. One-step operations can also be run quickly from the Recent/Favorite actions. And Combine Sheets & Consolidate Sheets can combine data using a formula that will auto-reflect all changes made in source sheets.
As for your second question, could you please give us more details? What do you mean by refreshing the ENTIRE sheet? Thank you.
Is it possible to automatically combine duplicated rows? Instead of manually doing it every time. We do have spreadsheet where all orders come automatically. Once we receive a lot of orders, we have to manually duplicate rows. Is it possible for example to set up fixed time day or two times a day and merge combine duplicated rows?
Thank you for your question.
If you are using the Combine Duplicate Rows tool, I'm afraid it's currently impossible to set up a certain time for the add-on to be run. You need to run it manually each time you want to combine duplicate rows. But I will forward your request regarding trigger support to our developers for consideration.
At the moment you can use scenarios as an alternative. You can save the settings you use most often and give this set a name – this is your scenario. Once you run it, your sheet will be processed right away, and you won't need to go over the same steps again. You can view, edit, and delete scenarios quickly anytime. Feel free to check the detailed instructions on how to work with scenarios on this help page.
If you have any other questions or need further assistance, please email us at firstname.lastname@example.org.
Do I understand correctly that if I buy two "Power Tools add-on for Google Sheets, 12-month subscription" licenses, I will receive two activation codes for 12 months for my two different accounts (regardless of which computer they will work on) ?
If you purchase two Power Tools subscriptions at a time, you will receive 1 activation key for both subscriptions. This key will allow you to activate the add-on under 2 different Google accounts. If you need 2 different activation keys, please make separate orders.
In case you have more questions, please don't hesitate to email us at email@example.com.
Does it have an auto-repeat facility for the new data added in the sheet?
Thank you for your question. For us to be able to help you better, please email us at firstname.lastname@example.org with a detailed description of your task. Please also let us know if you have tried any of our tools to solve it. Thank you.
Hi, what is the monthly charge for this tool?
Sorry, we don't have a monthly subscription for the add-on. We offer only a 12-month and a lifetime plan, both with a one-time payment. Thank you.
Hi, I want to compare prices (from monthly prices catalogue) to same destinations from different companies (some have got the destinations and some don´t). I want to see a column with the destinations that operate both companies and their prices (so I can check which destination is cheaper between both companies)
Is there any way to do that?
Thanks in advance!
Thank you for your message. I have just replied to you by email.
Eu consigo colocar o Power Tools em português? Só me falta isso para ele ser perfeito para mim.
Thank you for your comment. I'm really sorry, the add-on is available in English only.
How to uninstall the addon, I don't use it anymore and there is nothing in my addons > Manage addons section.
If I go to power tools it wants me to install, but its in the addons dropdown and keeps telling me that my free trial has expired.
Can't work out how to get rid of it.
Thank you for contacting us. I'm really sorry you are having issues with our software.
Please install the add-on anew and then uninstall it through Add-ons > Manage add-ons. Thank you.
quiero convertir de mayusculas a ninusculas y ya no me deja
Thank you for your comment. Please describe the problem in more detail. If you get any error message, please take a screenshot and send it to email@example.com
Want to be able to show other 2 R600,00 paid by client in rows under merge and combine. The Total is correctly calculated.
R600,00 29/07/2020 R2600,00
I have just replied to you by email. Please check your Spam/Junk/Trash folders if you don't see it in your Inbox.
I thought this add-on would do freeze panes but I don't see it
Power Tools indeed has the Freeze panes tool. You can run it by clicking the second icon on the smart toolbar at the top of the Power Tools pane: https://www.ablebits.com/docs/google-sheets-smart-toolbar/#freeze-rows-columns
If you have any questions or need further assistance, please let us know.
Your tool look great,
I need to do one thing,
Copy and paste a column to another one, but keep the original text of the second column and have the both text...
You can split...but join ???
Thank you for your comment. I've just replied to you via email. Please check your Inbox.
Please inform me, if I can merge duplicates by last date inserted?
If you are interested in our Combine Duplicate Rows add-on, it merges duplicate rows by a key column(s). So if you have a column with the "last inserted" dates, you may choose it as one of your key columns and the tool will combine the rows based on these dates.
Please check out the tool's manual as well, I believe you'll find it helpful: https://www.ablebits.com/docs/google-sheets-combine-duplicate-rows/
I see that I can mark my favorite actions with a star to have quick access to them in Favorite Tools bin at the bottom of the sidebar, but I don't know where I would add a star to do that. I also don't see any tools listed in the Recent Tools bin. How can I take advantage of those?
Thank you for your comment.
I'm sorry, but only simple one-step operations can be added to the list of Recent and Favorites tools. You see, merging sheets or removing duplicates, for example, involves 4 or 5 steps that have different settings depending on the spreadsheet where you run the add-on. Thus only one-click tools can be found in the Recent tools list where you can mark them with a star and add to your Favorites list.
I need to generate 2500 unique 3 string uppercase alphanumeric codes. Can not duplicate even in a different order (example: M8V, V8M). Only using A-Z and 1-6. Is there a code for this? Thank you.
Hello, is there a way to get Power Tools to run automatically when a new row of data is added?
I'm afraid not.
All tools should be run each time you want to process the data. Some one-click operations (except the wizard-based add-ons from Merge & Combine, Dedupe & Compare, and Randomize) can be started quickly from the Recent/Favorite tools tabs at the bottom of Power Tools.
We purchased a lifetime subscription on 05.18.19 but today, we were told that our TRIAL period has expired and being prompted to purchase.
You see, there's an issue on the side of Google that occurs when you are logged in under more than one account. This may force the tool to lose your key. Unfortunately, we can't control or bypass this issue, so I kindly ask you to sign out and log back in only under the subscribed account.
Then please try to unlock the tool again using your activation key.
If this doesn't help, please email us to firstname.lastname@example.org. Thank you.
If I purchase a lifetime subscription and I have two Google accounts used for different personal business, can I use the same product key to activate Power Tools on both?
Thank you for your question.
Please note that each subscription is account-based, meaning it can be activated under one Google account at a time. If you want to use the add-on under two accounts, then you need to get two subscriptions. To obtain multiple subscriptions with one payment, simply change the number of required licenses on the purchase order page.
Alternatively, you can transfer the subscription from one account to another when it is necessary: https://www.ablebits.com/docs/gsuite-add-ons-licensing/#transfer-subscription
Please let us know if you have any other questions.
hello, I am having some problems merging sheets. i have been following the same instructions but when I changed the document only a few cells would be updated. I deleted all formulas, checked the content, deleted all duplicated but nothing worked. Any suggestions?
Thank you for contacting us.
Since we need some details on the issue to be able to help you, our support team will email you shortly.
Thank you for your understanding.
Do you have something that will keep a Google Sheet sorted on a specific Column?
I'm seeing some formula stuff that does this but I'm lazy and want to point and click :)
Thanks in advance!
Unfortunately, we do not have such an add-on in our Power Tools. However, it looks like the standard Sort Range option available in Google Sheets or the =SORT function may be helpful.
Please let us know if there is anything we can help you with.
I've just add on the Power Tools for testing with my Google Sheet. I need to remove the empty row but nothing happen. What should I do? Thanks
If you need to get rid of blank lines within the data, make sure to select the option Remove all empty rows.
In case you're trying to delete all blanks after your table, pick to Remove unused rows instead.
If nothing still helps, please send us the screenshot of your data to email@example.com.
We'll do our best to help.
o power tools é pago? usei apenas uma vez.
Thank you for your question, Abner.
Our Power Tools offers a 30-day trial period. Once it expires, you are to either order a subscription or uninstall the add-on.
Should you have any other questions, feel free to contact us at firstname.lastname@example.org.
If I click the add-on tab, I can see the Help button on Power Tools, but I cannot see the Start button.
How do I see the Start button?
Thank you for contacting us. I'm sorry you are having a difficulty of this kind.
Reloading the spreadsheet should help and the "Start" option should appear in the menu.
If this doesn't help, please email us to email@example.com with your browser version and operating system you use.
We'll do our best to assist you.
We purchased a lifetime subscription on 05.24.18 but today, 11.09.18, we were told that our TRIAL period has expired and being prompted to purchase.
So sorry to hear you've encountered this difficulty with the add-on.
We’ve got your email in our support Inbox and will answer it as soon as possible.
If you have any other questions regarding your orders, please send them to our support email: firstname.lastname@example.org.
On March 12, 2018, I paid my yearly subscription in full for USD $29.99 (reference Number: YK5GRV) and today (October 6, 2018), the Power Tools is asking me to either buy now or enter a key. Why?
What is going on?
We've got your message in our support email inbox and will reply to it as soon as possible.
Thank you for your time and understanding.
I used power tools to create this formula: =COUNTA(valuesByColor("#ffffff", "#000000", '10121685 PENDING RELEASE'!V7:V12))
and it's definitely returning incorrect results. Can you please advise why?
Thank you for reporting this problem to us.
Please email us to email@example.com with the screenshot of your source data and the result you're getting.
We'll do our best to help.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!